DB2 Column length limitation


Can anyone help me how to come out of 30 bytes column length limation in DB2
some one suggested me to use DB2 UDB V8.0, but not sure.

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

nope, incorrect, in v8 the column name cannot exceed 30 charcaters
These are the max limits for V8.2.2

Column name is still 30.


Longest authorization name (can only be single-byte characters)  30  
Longest constraint name  18  
Longest correlation name  128  
Longest condition name  64  
Longest cursor name  18  
Longest unqualified column name (nickname)  128  
Longest data source index name  128  
Longest data source name  128  
Longest data source table name (remote-table-name)  128  
Longest external program name  8  
Longest host identifier a  255  
Longest identifier of a data source user (remote-authorization-name)  30  
Longest label name  64  
Longest method name  18  
Longest parameter name b  128  
Longest password to access a data source  32  
Longest savepoint name  128  
Longest schema name c  30  
Longest server (database alias) name  8  
Longest SQL variable name  64  
Longest statement name  18  
Longest transform group name  18  
Longest unqualified column name  30  
Longest unqualified package name  8  
Longest unqualified user-defined type, user-defined function, user-defined method, buffer pool, table space, database partition group, trigger, index, or index specification name  18  
Longest unqualified table name, view name, stored procedure name, sequence name, nickname, or alias  128  
Longest wrapper name  128  
sateesh_pAuthor Commented:
It says "Longest unqualified column name (nickname)  128 ", can I use this some way in my query so that I can get 128 bytes.

Thanks in advance,

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sateesh_pAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.