Problem Note 47285: Null values might be appended to the end of VARCHAR variables when data is retrieved from DB2 in the z/OS operating environment
 |  |  |  |  |
Variables that are defined as type VARCHAR in a DB2 database might have null values &$40;'00'x&$41; instead of blank spaces ('40'x) appended to the end of the value. This problem occurs when you use SAS/ACCESS® Interface to DB2 to read the data into the SAS® System under z/OS. This behavior results in a different value in SAS than what is stored originally in DB2.
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.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H16.html#47285A 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#47285A fix for this issue for SAS/ACCESS Interface to DB2 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J41.html#47285| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2012-09-12 16:39:55 |
| Date Created: | 2012-08-22 14:58:19 |