Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :