SUPPORT / SAMPLES & SAS NOTES
Problem Note 45205: The DB2UTIL procedure inserts garbage characters into CHAR and VARCHAR variables
 |  |  |  |
If you use the DB2UTIL procedure (PROC DB2UTIL) to insert new rows into an existing DB2 table, an incorrect value might be stored in the DB2 table. This occurs when the DB2 table contains variables defined as CHAR or VARCHAR and those variables have a length greater than 200. PROC DB2UTIL might put garbage characters in the value it is passing to DB2 somewhere after the 200th character.
To work around this issue, use the LIBNAME engine and insert the rows using either the SQL or APPEND procedure.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP4 | 9.4 TS1M0 |