Problem Note 46215: A READBUFF option set to >1 might lead to errors when you access SAS/ACCESS® Interface to DB2 in the z/OS operating environment
Using a READBUFF value >1 when reading a SAS/ACCESS to DB2 table on z/OS might result in the following errors:
DB2 WARNING:
RESULT OF SQL STATEMENT:
DSN00354W A ROWSET FETCH STATEMENT MAY HAVE RETURNED ONE OR MORE ROWS OF
DATA. HOWEVER, ONE OR MORE WARNING OR ERROR CONDITIONS WERE
ALSO ENCOUNTERED. USE THE GET DIAGNOSTICS STATEMENT
FOR MORE INFORMATION REGARDING THE CONDITIONS THAT WERE
ENCOUNTERED
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: 354 SQLSTATE: 01668 SQLERRP: DSNXEBR
DB2 WARNING:
RESULT OF SQL STATEMENT:
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 2 REASON CODE: 0
SQLCODE: 100 SQLSTATE: 02000 SQLERRP: DSNXRFN
DB2 ERROR:
RESULT OF SQL STATEMENT:
DSN00305E THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER
6 BECAUSE NO INDICATOR VARIABLE IS SPECIFIED
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 1 ERROR CONDITION: 3 REASON CODE: 0
SQLCODE: -305 SQLSTATE: 22002 SQLERRP: DSNXROHB
This issue occurs when the SAS/ACCESS to DB2 table has a field defined as a VARCHAR with an odd length and that variable contains a NULL value.
To work around the issue, do not use a READBUFF value >1. Alternatively, you can change the length of the VARCHAR field to an even length.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2013-02-28 10:05:31 |
Date Created: | 2012-04-04 10:06:07 |