Problem Note 6484: PROC DB2UTIL can insert garbage into DB2 columns that are defined as
VARCHAR
When using PROC DB2UTIL to insert data from a SAS data set it is
possible to end up with garbage appended to the end of the value in the
SAS column. This can occur if the DB2 column is defined as a VARCHAR
with a length greater than 200. PROC DB2UTIL is incorrectly padding the
field with blanks up to 200 bytes but not for the entire width. This
is incorrect behavior and is caused by the fact that this procedure
is not designed for character fields greater than 200. However, the
problem occurs even if the SAS data set does not contain any columns
that long. It is based on the length of the field as defined in DB2.
The current workaround is to switch to some other method of inserting
the data like PROC APPEND via the LIBNAME engine.
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#006484
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.1 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 ==> Procedures ==> DB2UTIL
|
| Date Modified: | 2002-09-11 16:36:21 |
| Date Created: | 2001-12-12 14:01:59 |
