[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22

[DS_MJ]

Hello:

In the Server Job I am loading data directly into the DB2 Table using the DB2 Plugin. However I am getting the following error:

Job name:[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22

The job flow is as follows:

Code: Select all

                                        HashFile
                                            |
                                            \/
Input file ---> Link Partitioner --->Shared container--->Link collector--->Transform --->Db2 Plugin

Could anybody explain what this error means...?

Thanks in advance.

__________
DS_MJ

[DS_MJ]

Furthermore about this job.

I am doing a direct insert Update into the DB2 table.
- My Update Actions is set to Update existing or insert new rows since most of the row will be updates.
- Set Array Size to 1 due to insert/update and
-Transaction size to 0 since we want to commit the rows after all rows are loaded.
- Configured for defaults in the Transform.