Running a stored procedure through datastage

in_finity307 · Post by **in_finity307** » Wed Jun 17, 2009 6:28 am

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?

chulett · Post by **chulett** » Wed Jun 17, 2009 7:04 am

Probably ODBC. Or run it from your command line using whatever option you have there, such as sqlplus for Oracle.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 17, 2009 4:20 pm

Probably not ODBC, which requires that the SP be able to handle a record set. More likely Stored Procedure stage.

chulett · Post by **chulett** » Wed Jun 17, 2009 4:23 pm

Guess I was think'n that backwards. And I believe the SP stage requires at least one input parameter.

Sreenivasulu · Post by **Sreenivasulu** » Thu Jun 18, 2009 3:35 am

The input parameter can be a dummy record from row generator stage

Regards
Sreeni