Locate SQLXRC and SQLXMSG

[SABAT]

Hi,

Some of my programs use SAS for insert/update into DB2 tabels in mainframe. While running a program, I got an error message "A DB2 error has occurred while processing this statement.The DB2 return code and error message are contained in the SQLXRC and SQLXMSG macro variables."
But I am not able to locate these variables. I do see that my code has the statements as
%put &sqlxrc;
%put &sqlxmsg;

Could someone help me find out these variables?

Thanks,
Sarmi

[LinusH]

Well, these are the refered macro variables. You should have these %put's right after your SQL that updates your DB2 tables. The contents of these macro variables will be printed to the SAS LOG.

/Linus