SQL Error - BigInt datatype

[fletchsod]

Okay, I got this error...

--snip--
SQL error: [IBM][CLI Driver][DB2/6000] SQL0408N An UPDATE, INSERT, or SET transition-variable value is not compatible with the data type of its target column "TOTAL_CUST_INQ". SQLSTATE=42821 , SQL state 22005 in SQLExecDirect
--snip--

So, what do I need to convert the TOTAL_CUST_INQ to BIGINT data-type? That is the data-type it use...

 

[fletchsod]

Fixed...

Since BIGINIT the data-type so I don't need the quote around the number value as part of the UPDATE syntax string. My mistake...