DB2 Plugin

iwin · Post by **iwin** » Thu Sep 01, 2005 9:02 am

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.

gpatton · Post by **gpatton** » Thu Sep 01, 2005 9:33 am

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?

iwin · Post by **iwin** » Thu Sep 01, 2005 9:42 am

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

gpatton · Post by **gpatton** » Thu Sep 01, 2005 11:53 am

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

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Sep 01, 2005 2:48 pm

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

iwin · Post by **iwin** » Thu Sep 01, 2005 4:52 pm

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