You are hitting one of the sql limits.




Longest unqualified column name (30 bytes) 30









"Thallam Raghu
Prasad "
<db2udbdba-ezmlms To
hield-x13515340.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc

01/30/2006 01:44 Subject
AM truncated column alias to 30
characters










hi,

I would like to give some clarity of the context.
I have a java program which forms a dynamic SQL query as part
of the
application.
When I pass the query to db2 to get fired.
I am facing a problem with db2 is truncating the alias name
automatically to 30
which will not match my select clause and the where cluase
causing
an exception leads to application fail.

At first cut I want to check whether any possible way at DB2
level
to solve the problem.
Is there a way to increase the maximum length for Column Alias
Name
in DB2.
I am using 8.2 version

Thanks in advance.
Raghu.

----------------------------------------------------------- NOTICE
------------------------------------------------------------
This email and any files transmitted with it are confidential and are
solely
for the use of the individual or entity to which it is addressed. Any use,
distribution, copying or disclosure by any other person is strictly
prohibited. If you receive this transmission in error, please notify the
sender by reply email and then destroy the message. Opinions, conclusions
and other information in this message that do not relate to official
business of the company shall be understood to be neither given nor
endorsed
by NIIT or NTL. Any information contained in this email, when addressed to
Clients is subject to the terms and conditions in governing client
contract.


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page