topic Re: Execute a Teradata Stored Procedure from SAS Data Itegration Studio and take the status of execu in Developers

Execute a Teradata Stored Procedure from SAS Data Itegration Studio and take the status of execution

Triz — Fri, 04 Dec 2020 13:05:05 GMT

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

Re: Execute a Teradata Stored Procedure from SAS Data Itegration Studio and take the status of execu

LinusH — Fri, 04 Dec 2020 13:55:21 GMT

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.