Database tablename length in DS
Posted: Tue Aug 11, 2009 2:58 am
Hi All,
I am having very long table names in the database which i want to use in DB2 stage in DS. I want to know that is there any constraint on the length of the table name? If i give a long table name, i get the buffer overflow error. I tried fixing the error by increasing the buffer size, by emptying the scratch disk, but of no use. Only when i used a short tablename, the issue got resolved.
Could anybody pls help me know if there is any such constraint and if it is then upto what length the name can be?
Also, is there method or parameter value which I can change to increase the limit.
Thanks in adv
I am having very long table names in the database which i want to use in DB2 stage in DS. I want to know that is there any constraint on the length of the table name? If i give a long table name, i get the buffer overflow error. I tried fixing the error by increasing the buffer size, by emptying the scratch disk, but of no use. Only when i used a short tablename, the issue got resolved.
Could anybody pls help me know if there is any such constraint and if it is then upto what length the name can be?
Also, is there method or parameter value which I can change to increase the limit.
Thanks in adv