Hello, I need to execute a Stored Procedure (SP) loaded in a Teradata Database. This Stored Procedure return the status of execution, and I need to take this status to determine the next steps in my workflow. I execute the SP using:
proc sql;
execute (call bd.procedure_name(status_var));
...
Is there any way to take the value of 'Status_var'?
Thank you very much in advance
Regards,
Beatriz
Generally speaking, you cannot use EXECUTE if you want to feed the resukt back to the calling SAS session.
You have to use the SELECT * FROM CONNECTION TO construct.
But, this uses a query as a parmeter. And id understand TD SP correctly, the result is fed back to avariable, rather than a query result.
So my guess is that this hard to accomplish OOTB.
Workaround? - if you can store the status_var in a table, then query that in a seconf call using SELECT * FROM CONNECTION TO.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: