SAS Support Site Home | Samples and SAS Notes Home
SAS Notes V6-QUERY-D722
Table aliases incorrect when you build a column in the SQL Query Window


A query may be built with incorrect aliases to the column names when you define a expression in the SQL Query Window.

The problem has been corrected for the following access modes at Release6.12 TSLEVEL 045: DB2, DB2/2, DB2/6000, ORACLE, SYBASE, SQL/DS and RDB.


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

System Release Reported Release Fixed
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 TS408 6.12 TS045  
VM/ESA (CMS) 6.09 TS450  
OS/390 (MVS) 6.09 TS450  
OpenVMS VAX 6.09 TS450  
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  
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