Problem Note 48272: An arithmetic exception in an explicit pass-through query to DB2 on a z/OS system might result in incorrect results
 |  |  |  |  |
Incorrect data might occur when you use explicit pass-through with SAS/ACCESS® Interface to DB2 in a z/OS operating environment. The incorrect data occurs when DB2 returns a warning due to an arithmetic exception; for example, a division by zero.
To determine what the DB2 warning was, do one of the following: Either take the query and run it outside of SAS using something like SPUFI (SQL processor using file input), or do a Call Attachment Facility (CAF) trace by allocating a DSNTRACE data set and look in the generated trace messages for an SQLCODE that is not equal to 0.
To work around this issue, fix the code that led to the arithmetic exception.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8.2 TS2M0 | 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#48272A 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#48272| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2012-11-01 12:51:42 |
| Date Created: | 2012-10-25 14:41:41 |