SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 40226: Incorrect results might occur when you specify the READBUFF= option with SAS/ACCESS® Interface to DB2 in the IBM z/OS operating environment

DetailsHotfixAboutRate It

Incorrect results might be generated when the following events occur:

  • Under z/OS, you set the READBUFF= data set option to a value that is greater than the number of rows that will be fetched when you query a DB2 table using SAS/ACCESS Interface to DB2.
  • The query that you submit contains a summary function for a column that accepts null values.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Applying this hot fix requires you to perform a DB2 bind with new database request module (DBRM) members. Even if you have completed the bind for the third maintenance release for SAS 9.2 (TS2M3) previously, you must perform the bind again with these new DBRM members. For more details, see SAS Note 39564, "SAS® 9.2 (TS2M3) Database Request Module (DBRM) members that are needed for the DB2 bind are not downloaded during the installation".



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.2 TS2M39.3 TS1M0
* 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.