SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-QUERY-D759
CONTAINS and SOUNDS LIKE operators incorrectly passed to the database


It is possible for you to build a WHERE condition in the SQL Query Window that contains an operator not supported by the DBMS system you are using. The query syntax will generate a DBMS specific error when it is executed.

This problem has been corrected at 6.12 TSLEVEL 045 for the following access modes: DB2, ORACLE, SYBASE, SQL/DS, INGRES and INFORMIX.


Products: BASE
Component: QUERY
Priority: HIGH
Status: Outstanding Problem
Date: Tue, 25 Nov 1997

System Release Reported Release Fixed
Windows NT 6.11 TS040 6.12 TS045  
Windows 95 6.11 TS040 6.12 TS045  
AIX/6000 6.12 TS020 6.12 TS045  
HP-UX Operating Systems 6.12 TS020 6.12 TS045  
VM/ESA (CMS) 6.08 TS407  
OS/390 (MVS) 6.08 TS407  
IBM OS/2 6.08 TS408 6.12 TS045  
OpenVMS VAX 6.08 TS407  
VSE/ESA (VSE) 6.08 TS407  
Windows 3.11 6.08 TS407 6.12 TS045  
VM/ESA (CMS) 6.09 TS450  
OS/390 (MVS) 6.09 TS450  
OpenVMS VAX 6.09 TS450  
AIX/6000 6.09 TS037 6.12 TS045  
IBM OS/2 6.12 TS020 6.12 TS045  
HP-UX Operating Systems 6.09 TS037 6.12 TS045  
Solaris 6.09 TS037 6.12 TS045  
DEC Ultrix 6.09 TS037  
OpenVMS Alpha 6.09 TS039 6.12 TS045  
AIX/6000 6.11 TS020 6.12 TS045  
HP-UX Operating Systems 6.11 TS020 6.12 TS045  
IBM OS/2 6.11 TS020 6.12 TS045  
Solaris 6.11 TS020 6.12 TS045  
Windows 3.11 6.11 TS020 6.12 TS045  
Intel ABI 6.11 TS040  
Silicon Graphics Unix 6.11 TS040  
Compaq Tru64 Unix 6.11 TS040  
Solaris 6.12 TS020 6.12 TS045  
OpenVMS Alpha 6.12 TS020 6.12 TS045  
Windows 3.11 6.12 TS020 6.12 TS045  
Windows NT 6.12 TS020 6.12 TS045  
Windows 95 6.12 TS020 6.12 TS045  

No Fixes Available