DSXchange

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

ODBC?

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