Problem Note 14108: Updating a DB2 table with MODIFY may fail
In SAS 9.1.3 (9.1 TS1M3), you may receive an error when doing a MODIFY
in a DATA Step on a DB2 table even if the code worked in previous
releases of SAS. The error will look like the following even though it
was an update and not an insert that was going to be submitted to DB2:
ERROR: Insert rejected. Data conversion for column XXX failed.
The problem can occur when the name and number of variables in the DB2
table do not match those in the SAS data set. However, if the error
does occur, the only current circumvention is to make the variables
match in both name and number.
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#014108
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014108
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.1 TS1M3 SP2 | 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: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> DB2
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2005-01-26 13:09:28 |
| Date Created: | 2005-01-04 15:22:33 |
