|
V6-SQL-D487
SQXEXTR CAN DO NO WHERE STUFF message when executing PROC SQL
|
It is possible to receive an error message when joining a SQL inline or
standard view that contains PROC SQL Pass-Through code accessing one
or more DBMS tables with another SAS data file. Typically, the SAS
data file is a SAS data set(s) or a view of a SAS data set(s). An errormessage is written to the SAS Log when the SQL optimizer attempts to
pass a subset condition to the database that should be processed in SAS.
You will receive the following error message:
ERROR: A bug in SAS has been encountered. Please call your SAS
SAS Representative and report the following message:
sqxextr can do no where stuff
The problem began in the following release levels: Release 6.08 TS420, Release 6.09 TS042, Release 6.09E TS450, Release 6.11 TS020 and Release 6.12 TS020. A circumvention is to create a SAS data set of the DBMS data. The problem has been corrected for Releases 6.09, 6.11 and 6.12 in the maintenance Release 6.12 TS045. The problem has been corrected for Releases 6.08 and 6.09E in Release 6.09 TS460.
| Products: | BASE |
| Component: | SQL |
| Priority: | HIGH |
| Status: | Outstanding Problem |
| Date: | Tue, 21 Oct 1997 |
| System | Release Reported | Release Fixed |
| VM/ESA (CMS) | 6.08 TS420 | 6.09 TS460 |
| OS/390 (MVS) | 6.08 TS420 | 6.09 TS460 |
| OpenVMS VAX | 6.08 TS420 | 6.09 TS460 |
| VSE/ESA (VSE) | 6.08 TS420 | |
| VM/ESA (CMS) | 6.09 TS450 | 6.09 TS460 |
| OS/390 (MVS) | 6.09 TS450 | 6.09 TS460 |
| OpenVMS VAX | 6.09 TS450 | 6.09 TS460 |
| AIX/6000 | 6.09 TS042 | 6.12 TS045 |
| HP-UX Operating Systems | 6.09 TS042 | 6.12 TS045 |
| Solaris | 6.09 TS042 | 6.12 TS045 |
| OpenVMS Alpha | 6.09 TS044 | 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 | |
| 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 |
| IBM OS/2 | 6.12 TS020 | 6.12 TS045 |
| 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