17998 - Accessing a DB2 table via a LIBNAME may result in a +239 error

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

Product Family	Product	System	SAS Release
			Reported	Fixed*
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.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#017998

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#017998

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