SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 36130: Running large SQL queries in the AIX operating environment can generate results with missing values

DetailsHotfixAboutRate It

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 FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SAS64-bit Enabled AIX9.1 TS1M3 SP49.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.