DSXchange

Posted: **Sat May 03, 2008 4:39 pm**

I am using stored procedure stage to execute a DB2 Stored procedure that takes 1 input parameter and outputs 4 parameter. The job aborts with this message

APT_CombinedOperatorController,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0002W Data truncated. SQLSTATE=01004

What could be wrong? How to address this?

Posted: **Sat May 03, 2008 6:56 pm**

We do not even attempt to solve problems reported by this operator.

Disable operator combination so that you can discern which stage (operator) is actually generating the error.

Posted: **Sun May 04, 2008 8:09 am**

Ray,

How would I do that in DataStage? Is it something with Data Stage or at DB2 Stored Procedure side?

Posted: **Sun May 04, 2008 4:30 pm**

You could have searched the forum rather than waiting for me to awake from my beauty sleep.

Bring environment variable APT_DISABLE_COMBINATION into your job as a job parameter and set it to True.

Every stage can also have its combinability set on the Advanced tab.

DSXchange

Error while Executing DB2 Stored Procedure

Error while Executing DB2 Stored Procedure