Page 1 of 1
Running a stored procedure through datastage
Posted: Wed Jun 17, 2009 6:28 am
by in_finity307
Hi,
I have a stored procedure with no input and output parameters. I want to call it through a Datastage job. Which stage can be used?
Posted: Wed Jun 17, 2009 7:04 am
by chulett
Probably ODBC. Or run it from your command line using whatever option you have there, such as sqlplus for Oracle.
Posted: Wed Jun 17, 2009 4:20 pm
by ray.wurlod
Probably not ODBC, which requires that the SP be able to handle a record set. More likely Stored Procedure stage.
Posted: Wed Jun 17, 2009 4:23 pm
by chulett
Guess I was think'n that backwards. And I believe the SP stage requires at least one input parameter.
![Confused :?](./images/smilies/icon_confused.gif)
Posted: Thu Jun 18, 2009 3:35 am
by Sreenivasulu
The input parameter can be a dummy record from row generator stage
Regards
Sreeni