Hi All
I am trying to call a stored procedure from a datastage job through ODBC Enterprise Stage.
The error is like this :
ODB_ROLLBACK_STOREDPROCE: Write mode failure: exec CTRL.DBo.sp_rollback_cp, '821001',
'CTRL.DBo.LoadStatus','CPY.testcopy.WH_EMP' doesn't exist.
The 4 parameters i am passing are stored procedure name, Loadstatusid,control table and target table .
i am using SQLSERVER 2008 database.
Any thoughts , please share
Regards
RK
issue while executing stored procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am