Problem Note 42115: Retrieving long character variables from DB2 in the z/OS operating environment can return incorrect results
 |  |  |  |  |
Reading a DB2 table with SAS/ACCESS® Interface to DB2 on z/OS can result in an incorrect value for a character variable. The character length that this occurs with can vary between runs.
For example, lets say that the cutoff is 230. Any value longer than 230 characters will have the original data until the 230th byte, any additional bytes will be '00'x (NULL) instead of the original character. This continues until a record shorter than 230 characters is read. Once the shorter record is read correctly, any record after which is longer than 230 bytes, rather than the data being truncated at the 230th byte and the trailing bytes replaced with a '00'x they are replaced with '40'x (blank).
There is no workaround for this problem.
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.3 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#42115| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2011-01-19 15:14:46 |
| Date Created: | 2011-01-18 15:15:47 |