DSXchange

Hi,
I am trying to get data from DB2 plugin to Transformer and then to Flatfile. As i run the job individually,it is succesful but when i run the same job in a job sequencer i get an error below:

ValidateACU103FCustSetup..Transformer_50: [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
SQLExecute: Error executing statement 'SELECT COST_B4_PGM,CURRENT_COST,CREDIT_CODE_B4_PGM,CURRENT_CREDIT_CODE FROM CUSTOMER_ID=? AND ACU103F_ADDRESS_SEQ=? AND ACU103F_CONTACT_ID=? with NC'. See following DB2 message for details.

Please provide the error message that follows.

Also what version of DB2 are you on?

Have you verified that the parameters passed from the sequencer to the job when run are all correct?

Hi,
The next message i have is :
Attempting to Cleanup after ABORT raised in stage ValidateCustSetup..Transformer_50.
Yes, i have passed all the parameters for the job in sequencer.
Thanks

In your first post you said "See following DB2 message for details. "

What dis DB2 complain about. Can you post the DB2 message.

You need to see from where the 'with NC' appeared from?

Hi,
I have written the user defined sql "with NC" .
Thanks