Problem Note 46856: Using a value greater than 1 for the READBUFF option might result in wrong data when you access DB2 data on a z/OS system
 |  |  |  |  |
On a z/OS system, if you use the LIBNAME option with the READBUFF statement to read a DB2 table, do not specify a value >1 for the READBUFF value. Using a value >1 might result in incorrect data.
This problem can occur when your SQL procedure (PROC) query is retrieving any character variables that are defined in the DB2 table as VARCHAR.
The only workaround is to not use READBUFF >1.
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 | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B94.html#46856| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2013-02-28 10:07:20 |
| Date Created: | 2012-06-20 16:21:20 |