When you try to access a DB2 database, the query might not execute when the following is true:
- You run under z/OS 2.5.
- You run SAS® 9.3M2 (TS1M2) without Hot Fix J41008 or you run a version earlier than SAS 9.3M2.
Rather than an error, one of the following notes might appear when you try to access DB2:
NOTE: PROC SQL SET OPTION NOEXEC AND WILL CONTINUE TO CHECK THE SYNTAX OF STATEMENTS.
NOTE: Statement not executed due to NOEXEC option.
To receive an error, add the following options statement before your code:
options sastrace='d,d,d,d';
After you add the options, the following error occurs in the trace:
DB2: Entering db2m_get_colname()
DB2: (2) Exiting db2m_get_colname() with return code -2147483648
ACCESS ENGINE: Exiting dbidsci with ERROR, rc=0x80000000
The only workaround for this issue is to upgrade to a more recent version of SAS.