Problem Note 36130: Running large SQL queries in the AIX operating environment can generate results with missing values
 |  |  |  |  |
Running SQL queries against a large number of tables under AIX can generate results with missing values. (For example, the reported problem associated with this note had queries selecting data from 27 tables.) This problem occurs only on the AIX operating system.
The missing values can occur in tables or in views created by the SQL procedure.
Click 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 | Base SAS | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
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#036130A 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#036130| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> SQL |
| Date Modified: | 2009-06-08 09:21:40 |
| Date Created: | 2009-06-03 13:51:54 |