SAS/ACCESS Software for Relational Databases: Reference

SQL Procedure Pass-Through Facility Return Codes

As you use the PROC SQL statements that are available in the SQL Procedure Pass-Through Facility, any error conditions are written to the SAS log. The SQL Procedure Pass-Through Facility generates return codes and messages that are available to you through the following two SAS macro variables:

SQLXRC: contains the DBMS return code that identifies the DBMS error.
SQLXMSG: contains descriptive information about the DBMS error that is generated by the DBMS.

The contents of the SQLXRC and SQLXMSG macro variables are printed in the SAS log using the %PUT macro. The automatic macro variables SQLXRC and SQLXMSG are reset after each SQL Procedure Pass-Through Facility statement has been executed.

Chapter Contents
Previous
Next
Top of Page