Problem Note 4819: SAS/ACCESS view referencing DB2 table with character column wider than
200 bytes may produce errors
Accessing a DB2 access view descriptor which contains a character
variable whose length is greater than 200 bytes may result in an
error. The two most common errors are a -804 reason code 7, or an
S0C4 abend. The error does not always occur just because a long
variable is selected.
The problem occurs because PROC ACCESS is a Version 6
compatibility-only procedure. In Version 6, the maximum length of a
character variable is 200 bytes. In Version 8, the maximum length
increases to 32,767 bytes. This difference causes a problem since the
field has been defined in the view to be a maximum of 200 bytes, but
the DB2 engine is returning more data.
To prevent the error, add a format to the view descriptor that
specifies the length of the variable. For example, if the DB2
variable is defined as CHAR(250), adding:
FORMAT DB2-VARIABLE $250.;
prevents the error.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#004819
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 8 TS M0 | 9 TS M0 |
*
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: | medium |
| Topic: | SAS Reference ==> Procedures ==> ACCESS
|
| Date Modified: | 2002-04-22 16:07:59 |
| Date Created: | 2001-04-25 09:24:10 |
