SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-QUERY-D697
Incorrect table aliases when using a saved query in the SQL Query Window


An incorrect table alias may be generated when a query is first built using table aliases, the table aliases are removed and the query is saved so that it can be included in a later SQL Query Window session. When the saved query is used, the deleted table alias is displayed.

The problem has been corrected in SAS Release 6.12 TSLEVEL 045.


Products: BASE
Component: QUERY
Priority: HIGH
Status: Outstanding Problem
Date: Mon, 24 Nov 1997

System Release Reported Release Fixed
OpenVMS Alpha 6.12 TS020 6.12 TS045  
VM/ESA (CMS) 6.08 TS404  
OS/390 (MVS) 6.08 TS404  
IBM OS/2 6.08 TS404 6.12 TS045  
OpenVMS VAX 6.08 TS404  
VSE/ESA (VSE) 6.08 TS404  
Windows 3.11 6.08 TS404 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  
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.10 TS018  
Silicon Graphics Unix 6.10 TS018  
Macintosh 6.10 TS037  
Compaq Tru64 Unix 6.10 TS018  
IBM OS/2 6.10 TS019 6.12 TS045  
Windows 3.11 6.10 TS019 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  
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