SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14108: Updating a DB2 table with MODIFY may fail

DetailsHotfixAboutRate It
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 FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.1 TS1M3 SP29.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.