HI Guys,
I am using Datastage 7.5 server edition.. I need to know how to call Procedure in Datastage Oracle stage.
It's very urgent .. Please help me .
Thanks in advance ..
Regards,
kris
HOw to call procedure in Datastage Oracle Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Etiquette Note
We don't do urgent here. If you want urgent answers, sign up with your support provider for premium service, and learn the true cost of urgent.
Reconsider your requirement. Is calling a Stored Procedure for every row processed so necessary? It will be very slow. Can you not replicate the functionality in the ETL tool? Have you investigated the Stored Procedure stage? Have you investigated the ODBC stage? Why must it be the Oracle OCI stage?
We don't do urgent here. If you want urgent answers, sign up with your support provider for premium service, and learn the true cost of urgent.
Reconsider your requirement. Is calling a Stored Procedure for every row processed so necessary? It will be very slow. Can you not replicate the functionality in the ETL tool? Have you investigated the Stored Procedure stage? Have you investigated the ODBC stage? Why must it be the Oracle OCI stage?
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.
In the documentation you should find something called "Stored procedure stage". It is not installed by default. You will need to install it to every project in which you need to use it. We have been using it successfully for a while. I hope this works in Windows and server edition too. We have unix, parallel.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What kumar_s has in mind, I believe, is not a before/after subroutine (because Call, in the SQL sense, does not work there unless you wrap it in BCI function calls), but probably the Open/Close commands in the OCI stage.
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.
Open/Close for a Parallel job. He meant the 'Before SQL' or 'After SQL' tab of an OCI stage in a Server job can be used to call a stored procedure as long as they don't return anything.
Otherwise, use the STP or Stored Procedure stage which you have in your version.
Otherwise, use the STP or Stored Procedure stage which you have in your version.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Code: Select all
'Before SQL' or 'After SQL' tab
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'