Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: SQL0404N A string in the UPDATE or INSERT statement is too long for column

    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!

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Can you post the column defintions of Col1, Col2?

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

  3. #3
    Join Date
    Oct 2003
    Posts
    1

    Cool Re: SQL0404N A string in the UPDATE or INSERT statement is too long for column

    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

  4. #4
    Join Date
    May 2003
    Posts
    369

    thanx

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

    -scott

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •