https://communities.sas.com/t5/SAS-Programming/Locate-SQLXRC-and-SQLXMSG/m-p/64813#M14083 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.<BR /> <BR /> /Linus Fri, 05 Dec 2008 21:29:53 GMT LinusH 2008-12-05T21:29:53Z https://communities.sas.com/t5/SAS-Programming/Locate-SQLXRC-and-SQLXMSG/m-p/64812#M14082 Hi,<BR /> <BR /> 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." <BR /> But I am not able to locate these variables. I do see that my code has the statements as<BR /> %put &amp;sqlxrc;<BR /> %put &amp;sqlxmsg;<BR /> <BR /> Could someone help me find out these variables? <BR /> <BR /> Thanks,<BR /> Sarmi Fri, 05 Dec 2008 21:08:10 GMT https://communities.sas.com/t5/SAS-Programming/Locate-SQLXRC-and-SQLXMSG/m-p/64812#M14082 SABAT 2008-12-05T21:08:10Z https://communities.sas.com/t5/SAS-Programming/Locate-SQLXRC-and-SQLXMSG/m-p/64813#M14083 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.<BR /> <BR /> /Linus Fri, 05 Dec 2008 21:29:53 GMT https://communities.sas.com/t5/SAS-Programming/Locate-SQLXRC-and-SQLXMSG/m-p/64813#M14083 LinusH 2008-12-05T21:29:53Z