Error while Executing DB2 Stored Procedure

horserider · Post by **horserider** » 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?

ray.wurlod · Post by **ray.wurlod** » 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.

horserider · Post by **horserider** » 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?

ray.wurlod · Post by **ray.wurlod** » 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.