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.

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