Hi,
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...

Regards
shwetaj

hi shwetaj,

please check your definition into java program (data type).

bye
abel.

Hey,
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.

shwetaj

hi again,
I test create a table with a column varchar(4000) and insert a record with 1700 character and work fine.

how know the length of your record?

I run this select:
select length(column) from table.

Abel.

hi again,
I test create a table with a column varchar(4000) and insert a record with 1700 character and work fine.

how know the length of your record?

I run this select:
select length(column) from table.

Abel.