topic Re: ERROR: Teradata execute: No more spool space, Stop execution in New SAS User

ERROR: Teradata execute: No more spool space, Stop execution

dgoel — Tue, 01 Oct 2019 17:24:09 GMT

Hi,

I want to stop the execution of SAS Job when the following error is there:

ERROR: Teradata execute: No more spool space.

I am observing that SAS does not even get to know about it and it goes till the end of the Job and shows as completed. Does anyone has an idea to instead stop the job at that error? Maybe any Macro idea?

Re: ERROR: Teradata execute: No more spool space, Stop execution

Tom — Tue, 01 Oct 2019 18:03:07 GMT

It probably depends on how you are submitting the Teradata code that causes the issue.

Re: ERROR: Teradata execute: No more spool space, Stop execution

dgoel — Tue, 01 Oct 2019 18:05:01 GMT

I am calling the procedure there by connecting to teradata.

Re: ERROR: Teradata execute: No more spool space, Stop execution

Tom — Tue, 01 Oct 2019 19:13:49 GMT

@dgoel wrote:
I am calling the procedure there by connecting to teradata.

So I assume you did something like:

proc sql ;
 ....
execute(  .... )  by TERADATA ;

You should be able to check the SQLXRC and SQLXMSG macro variables.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473677.htm

Any return code or message that is generated by the DBMS is available in the macro variables SQLXRC and SQLXMSG after the statement completes.

Re: ERROR: Teradata execute: No more spool space, Stop execution

dgoel — Thu, 10 Oct 2019 22:05:22 GMT

Thank You so much. This worked. I was able to make the execution stop using these macro variables.