Hello,
Is there a way to execute a stand alone stored procedure? I have a data stage job which creates a table. The stored procedure uses this table and deletes records from about 20 tables. Is there a way to execute this stored procedure after the datastage job finished creating the initial table?
Thanks
achang
execute stored proc in job?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
It is available, Tony - in 7.5. In addition to the DRS (Dynamic Relational Stage) which is a whole 'nuther animal, there is a new SP or Stored Procedure stage. It allows usage of stored procedures as Source, Target or Lookup stages. Haven't taken it for a spin yet, but it is definitely there.
Oracle only right now, but other databases supported 'soon'.
Oracle only right now, but other databases supported 'soon'.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi,
U can execute a stored Procedure from Datastage.You will hv to choose the update action as call stored procedure from the target Stage.
Before that you will have to import the corresponding stored procedure
thro manager ,I think you must be aware of that.
As you have given a condition like you are creating a table in the target and then you have to fire the Procedure. You can call the stored procedure from the OCI Stage. In SQL tab you can choose after and call the procedure by CALL procname(param).
U can execute a stored Procedure from Datastage.You will hv to choose the update action as call stored procedure from the target Stage.
Before that you will have to import the corresponding stored procedure
thro manager ,I think you must be aware of that.
As you have given a condition like you are creating a table in the target and then you have to fire the Procedure. You can call the stored procedure from the OCI Stage. In SQL tab you can choose after and call the procedure by CALL procname(param).
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Stored procedures called from within DataStage jobs must process at least one row of data.
"Stand alone" suggests that your stored procedure does not fall into that category. If you have a licensed ODBC driver you might contemplate using a routine using BCI functions; otherwise you will need to use a "shell wrapper" as suggested.
"Stand alone" suggests that your stored procedure does not fall into that category. If you have a licensed ODBC driver you might contemplate using a routine using BCI functions; otherwise you will need to use a "shell wrapper" as suggested.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.