DSXchange

[quote]You could always take the logic from the stored procedure and build a DataStage job to accomplish the same thing, I would think. That would put the maintenance of it back into the ETL realm and not dependant on someone with PL/SQL (whatever the SQL Server equivalent is) skills.[/quote] Craig ...

Thanks for the response ray !! [quote="ray.wurlod"] What was the result when you imported this stored procedure definition? What columns were defined?[/quote] When I imported the definition, It said something like "Stored procedure has failed to report a result set . If this stored procedu...

Hi all !! I am trying to implement stored procedures (SQL Server) in Datastage..Most of my stored procs update/delete/insert rows into/from multiple tables..and donot take any input parameters. Also the procedures do not give out any output except a return code indicating the success or failure. Aft...