I was trying to disregard a pending approval on Hanarule with an enhanced query job.
here's what I put in the job.
|SELECT '0' AS HANARULE__SENTFORAPPROVAL, h.hanarulekey as HANARULE__PRIMARYKEY from HANARULE h where h.hanarulekey=418;
and What I got is
|Error while updating table: HANARULE : Data truncation: Data too long for column 'SENTFORAPPROVAL' at row 1
I have checked the data type in the column but I can't find what I did wrong with this.
Could you guys give me any comments one this ?