Calling Netezza Stored Procedure

nvalia · Post by **nvalia** » Thu Mar 05, 2015 11:47 am

Hi All,

v11.3 on Windows, Paralell Jobs

We need to call a Netezza Stored Proceure from within Datastage.
We have the Stored Procedure Stage but I do not see Netezza under Vendor options where we have Oracle, Teradata and so on..

Other way I can think of is calling the SP from a After Job Command in the Netezza Connector stage..is this the right way or is there some alternative approach/solution for this?

Thanks,
NV

chulett · Post by **chulett** » Thu Mar 05, 2015 2:16 pm

ODBC?

nvalia · Post by **nvalia** » Fri Mar 13, 2015 11:30 am

I managed to call it from the Netezza Connector stage after using a dummy Update Statement to a table (updates nothing) and call the Execute SP() from the After SQL so it gets executed only 1