Error Executing Database Query.[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver][DB2] SQL0404N A string in the UPDATE or INSERT statement is too long for column "". SQLSTATE=22001

Participating Frequently

Question

Error in update statement

Forum|Forum|15 years ago
May 6, 2010
1 reply
1024 views

Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][IBM][CLI Driver][DB2] SQL0404N A string in the UPDATE or INSERT statement is too long for column "". SQLSTATE=22001

This topic has been closed for replies.

BKBK

Community Expert

Could we see the SQL statement? It might just be what it says: A string in the UPDATE statement is too long for the column!

C

ColdfuisonDB2Author

Participating Frequently

update dl.tbrfdes set fee_desc = 'LOAN', fee_active_Ind = 'DC', fee_acaps_grp_code = 'Misc', fee_srch_la_code = 'N', fee_srch_cev_code = 'N', fee_srch_use_code = 'N', fee_srch_lntp_code = 'N', fee_srch_brnch_cd = 'N', fee_srch_state_cd = 'N', row_chng_tmstmp = 'ZZZH11', fee_srch_internet_src_cd ='N', fee_srch_fico_score_cd ='N', fee_srch_cnty_cd ='N' where fee_id = 'LF1 '

BKBK

Community Expert

row_chng_tmstmp = 'ZZZH11'

Shouldn't that value have to do with time?

Error Executing Database Query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded