Problem Note 15303: Unsupported query containing an in-line view causes invalid aliasing which results in suboptimal performance
 |  |  |  |  |
Since Sybase and MYSQL do not support in-line views, a simpler query is created when they are used with an alias. Because of invalid aliasing, a syntax error occurs similar to the one below:
ERROR: Prepare error: You have an error in your SQL syntax. Check
the manual that corresponds to the MYSQL server version for the right
syntax to use near 'select distinct D.'D_COMPTA' from 'BMGI01GICALD'
D) B, (selec SQL statement: select B.'D_COMPTA', A>'D_COMPTA',
A.'D_MOIS'.....
SAS® continues to process the query resulting in the correct output but suboptimal performance is received.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to SAP BW | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Sybase | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to PeopleSoft | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to R/3 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Oracle Rdb | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Informix | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to DB2 Server for VM | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to IMS-DL/I | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-OpenIngres | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-IDMS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-Datacom/DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Baan | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Adabas | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.1 TS1M3 SP3 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#015303A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#015303| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> Procedures ==> ACCESS |
| Date Modified: | 2005-10-10 08:50:18 |
| Date Created: | 2005-05-24 10:26:09 |