DATA Step, Macro, Functions and more

Locate SQLXRC and SQLXMSG

Reply
N/A
Posts: 1

Locate SQLXRC and SQLXMSG

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
Super User
Posts: 5,256

Re: Locate SQLXRC and SQLXMSG

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
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 540 views
  • 0 likes
  • 2 in conversation