Problem Note 42697: Incorrect results might occur when you specify the READBUFF= option with SAS/ACCESS® Interface to DB2 in the IBM z/OS operating environment
Incorrect results might be generated when the following events occur:
- You are using explicit pass-through to access DB2
- You set the READBUFF= option to something greater than 1 in your CONNECT TO DB2 statement
- You are retrieving at least 1 variable defined as a DECIMAL data type in DB2
- Your query includes an ORDER BY clause outside of the pass-through part of the query
The only workarounds are to either set the READBUFF=1, move the ORDER BY inside the pass-through part of the query, or sort the data in a subsequent step.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.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.
| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2011-03-16 13:14:24 |
| Date Created: | 2011-03-16 10:14:29 |
