Problem Note 20130: Aliases columns or aliased tables in the SQL procedure blocks Implicit
Pass-Through
Using the LIBNAME statement as the access method, PROC SQL queries that
contain aliased in-line views, aliased columns, or aliased tables can
cause incorrect textualization of the query.
Incorrect query textualization can prevent Implicit Pass-Through from
passing the query to the associated database for execution. As a result,
the query will be executed in SAS instead. Significant performance
problems can occur because of the potential for retrieving large amounts
of data that are returned to SAS before the processing is finished.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Linux on Itanium | 9.1 TS1M3 | |
| Linux | 9.1 TS1M3 | |
| z/OS | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| HP-UX IPF | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| OpenVMS Alpha | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | |
| Tru64 UNIX | 9.1 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2007-05-24 09:42:17 |
| Date Created: | 2007-05-02 09:45:26 |
