As you use the PROC
SQL statements that are available in the pass-through facility, any
error conditions are written to the SAS log. The pass-through facility
generates return codes and messages that are available to you through
these SAS macro variables:
contains the data source
return code that identifies the data source error.
contains descriptive
information about the data source error that is generated by the data
source.
The contents of the
SQLXRC and SQLXMSG macro variables can be written to the SAS log using
the %PUT macro. The contents are reset after each pass-through facility
statement is executed.