Accessing a DBMS table with a query that includes the data set option DBSASTYPE= causes implicit pass-through to be turned off. This is currently by design. Including any data set options in the query is one of the documented reasons that causes implicit pass-through to be disabled. If you have turned on tracing with the SASTRACE= system option, the following notes appear in your SAS log:

SAS_SQL:  Cannot handle dataset options.                                    
SAS_SQL:  Unable to convert the query to a DBMS specific SQL statement due  
          to an error.
ACCESS ENGINE:  SQL statement was not passed to the DBMS, SAS will do the   
          processing. 

One of the following errors might also appear in your SAS log if you are accessing a DB2 table on z/OS:

ERROR: DB2 prepare error: DSNT408I SQLCODE = -401, ERROR:  THE OPERANDS
      OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE. 

ERROR: (ACCDB2M041E) The column T1_ID does not exist.

There is currently no workaround for this problem.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at: