Problem Note 54627: Incorrect data might occur when you are reading a DB2 DECIMAL data type with an access view descriptor in a z/OS operating environment
 |  |  |  |  |
When you are using a view descriptor on a DB2 table under z/OS that includes a variable of the DECIMAL data type, the decimal portion of the value might be truncated. For example, a value of 15.23 might become 15.00. This does not occur with explicit pass-through or the LIBNAME engine.
To work around this issue, use the CV2VIEW procedure to create an explicit pass-through view.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.4 TS1M0 | 9.4 TS1M3 |
A fix for this issue for SAS/ACCESS Interface to DB2 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/S59.html#54627A fix for this issue for SAS/ACCESS Interface to DB2 9.4_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/S60.html#54627| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2014-11-26 12:23:29 |
| Date Created: | 2014-11-14 11:46:11 |