Problem Note 11239: Final WHERE clause not included in the SQL to be proccessed by the
database when using the LIBNAME ACCESS engine
When using the LIBNAME ACCESS engine, part of the WHERE clause may not
be passed to the DBMS for processing when associated with a subselect.
This may cause the process to fail if the database runs out of TEMP
space because the result set is larger than expected. It may also cause
more rows than expected to be returned to SAS.
A Technical Support hot fix for Release 8.2 (TS2M0) for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#011239
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#011239
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | 64-bit Enabled AIX | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | |
| HP-UX | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | |
| Solaris | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | |
*
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: | medium |
| Topic: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2004-03-12 09:37:17 |
| Date Created: | 2003-11-07 11:46:29 |
