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

[dgoel]

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?

[Tom]

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

[dgoel]

I am calling the procedure there by connecting to teradata.

[Tom · Accepted solution]

---

@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.

[dgoel]

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