issue while executing stored procedure
Posted: Thu Mar 18, 2010 5:27 am
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
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