We keep getting the error message for our DB2 UDB 7.2 database on AIX 5.2L (both are 32bit versions) SQL0404N A string in the UPDATE or INSERT statement is too long for column when we try to run the following SQL DB2 statement:

INSERT INTO table (Col1, Col2, TableName, RecordCount ) VALUES( {d '2003-10-24'}, '2003-10-25 17:55:05', 'CODES', 1)

Any tips on how to resolve this error in DB2? Thanks!

Can you post the column defintions of Col1, Col2?

I am not an expert on date or character manipulation, but what are "{" for?

We keep getting the error message for our DB2 UDB 7.2 database on AIX 5.2L (both are 32bit versions) SQL0404N A string in the UPDATE or INSERT statement is too long for column when we try to run the following SQL DB2 statement:

INSERT INTO table (Col1, Col2, TableName, RecordCount ) VALUES( {d '2003-10-24'}, '2003-10-25 17:55:05', 'CODES', 1)

Any tips on how to resolve this error in DB2? Thanks!

-------------------

Hi,

First check the column type and make sure the value you are trying to update/insert is within the limit. (For example if you have column type as SMALLINT and try to update/insert the value as 33000 then this will fail since the value allowed for smallint is 32xxx). If you have enough tablespace then this might of some help.

Good luck.

Raju

think that the parser software just choked on the query. when I reset the parser it ran fine. thanks for the help

-scott