The syntax section presents the syntax for the SQL pass-through facility statements and the CONNECTION TO component. For DBMS-specific details, see the DBMS-specific reference section for your SAS/ACCESS interface.
As you use the PROC SQL statements that are available in the SQL pass-through facility, any error return codes and error messages are written to the SAS log. These codes and messages are available to you through these SAS macro variables:
contains the DBMS return code that identifies the DBMS error.
contains descriptive information about the DBMS error that the DBMS generates.
The contents of the SQLXRC and SQLXMSG macro variables are printed in the SAS log using the %PUT macro. They are reset after each SQL pass-through facility statement has been executed. For details about these return codes, see Macro Variables for Relational Databases.