Problem Note 17998: Accessing a DB2 table via a LIBNAME may result in a +239 error
It's possible to receive a +239 when trying to access a DB2 table using
a LIBNAME engine if the DB2 table has more than 50 columns or if the
table has a column defined as a DISTINCT data type. Depending on how
you are accessing the table you may see one of the following messages:
ERROR: DB2 describe error: DSNT404I SQLCODE = 239, WARNING:
SQLDA INCLUDES 050 SQLVAR ENTRIES, BUT 106 ARE REQUIRED FOR 053
COLUMNS BECAUSE AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A
DISTINCT TYPE.
or
DB2 SQL Error, sqlca->sqlcode=239
Select 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.1 TS1M0 | 9.2 TS1M0 |
*
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 |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> DB2
|
| Date Modified: | 2006-07-10 09:48:41 |
| Date Created: | 2006-07-03 13:05:28 |
