DSXchange

Hi All,

I have job design as:

Dataset---->modify------>DB2 table where i have used update statment.

When i run the job individually means,it is completing successfully but when i run the job in sequence means it is aborting giving the error:db2CS_ORDER_FACT: ERROR during execution of DB2-CLI requests: SQL_ERROR; SQLSTATE = 42S02; NativeErrorCode = -204; Message = [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "CDW_STG.CS_ORDER_FACT" is an undefined name. SQLSTATE=42704

Could anyone please tell me why this job is failyng ?

Thanks & Regards,
Kalpana.

Your DB2 DBA would probably be able to help. As noted in your other post, the error is coming from DB2.

The database credentials that you are passing in the sequence would be wrong .Please check them.Looks like its the schema name which is wrong