Error in update statement

[ColdfuisonDB2]

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

[BKBK]

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!

[ColdfuisonDB2]

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]

row_chng_tmstmp = 'ZZZH11'

Shouldn't that value have to do with time?

[Adam Cameron.]

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

I reckon that's exactly what it is.  Check your column sizes compared to the values you are setting.

--

Adam

[ColdfuisonDB2]

Thanks for helping me out

I will check the size of data types.