Problem Note 50809: When you access DB2 under z/OS and the DB2 table contains a variable defined as DISTINCT or LOB, an error might occur
Querying a DB2 table that contains a LOB or DISTINCT data type and selecting more than 25 variables might result in an error similar to the following:
DB2 WARNING:
RESULT OF SQL STATEMENT:
DSN00237W SQLDA INCLUDES 50 SQLVAR ENTRIES, BUT 84 ARE REQUIRED BECAUSE AT
LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A DISTINCT TYPE
A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS:
ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 0
SQLCODE: 237 SQLSTATE: 01594 SQLERRP: DSNXEDC3
The job might also fail with an 0C4 abend similar to one of the following:
ERROR: System abend 0C4 occurred in module SASSQX function SQLMEM at
offset 000098.
ERROR: Traceback will be attempted...
NOTE: Traceback called
NOTE: Module Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASSQP SQPRSLV 000402 0
NOTE: SASSQLP SQLRSLV 0028A0 0
NOTE: SASSQLP SQLPREP 0000B8 0
NOTE: SASSQX SQLLOOP 0008DA 0
NOTE: SASSQL SASSQL 000302 0
NOTE: SASHOST UNKNOWN 002DD0 0
ERROR: Delete current task.
OR
ERROR: System abend 0C4 occurred in module SASXDBI function DESCRIB at offset
0000F4.
The only workaround is to break up the query so that no more than 25 variables are returned at a time.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M1 |
*
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-09-14 17:00:40 |
| Date Created: | 2013-08-20 13:57:59 |
