I have a problem. I am Using DB version 8.1. I have created a table which has a varchar field with length 3500 characters. Whenever I try to insert data in it, the message is truncated to 1023 or 1022 characters.
This happens when I execute the query through my java program. But an update to the same record explicitly done with a database entry tool takes the field value completely. But a insert done with the same tool again truncates the value to 1022 or 1023 characters.
Can somebody help me with this ?
Thanking in advance...
Thanks for suggesting that. But when I try to insert data through the DB2 command center...even then the characters are truncated. So irrespective of what data type i use in my java program...String data more than 1023 characters is not being inserted.