In SAS/ACCESS Interface to DB2, when you assign a libref and use the QUALIFER= option in a LIBNAME statement along with a PROC SQL SELECT statement that contains the DISTINCT parameter, the specified qualifier is ignored.

The following code illustrates this behavior:

SASTRACE output shows that the QUALIFIER= option is ignored in the SQL that is ultimately passed to DB2, as shown here:

DB2_2: Prepared: 7 1184677962 du_prep 0 SQL
select distinct sysibm.systables."NAME" from sysibm.SYSTABLES
FOR READ ONLY

In the following example, a second PROC SQL query is made using the same libref and a SELECT statement without the DISTINCT option:

For this example, SASTRACE output shows that the QUALIFIER= option IS honored in the SQL code that is passed to DB2:

DB2_5: Prepared: 22 1184678010 du_prep 0 SQL
SELECT  "NAME"  FROM sample.sysibm.SYSTABLES  FOR READ ONLY
23 1184678010

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

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: