Poon's Blog

db2 sql develop error--value is to long

keyword:db2,err,value,insert

*

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command. 

During SQL processing it returned:
SQL0433N  Value "hongkong paris trading company guangzhou representative office" is too long. 
SQLSTATE=22001

*

when you encounter this problem,

 you may check the table definition to see

if some field is too short to accept a long string.

maybe you can change a field 's length from varchar(20) to varchar(100).