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.
Error in DB2 stage
Moderators: chulett, rschirm, roy
Error in DB2 stage
Kalpana Marupudi
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 64
- Joined: Wed Sep 26, 2007 6:52 am
- Location: Syracuse ,NY