Problem Note 6839: SAS DATETIME format is used in PROC DB2UTIL delete operations rather
than the correct DB2 format
When using PROC DB2UTIL to delete records from a DB2 table based on a
datetime variable, the WHERE clause generated has the SAS datetime
formated using the SAS datetime format rather than the quoted string
that DB2 expects. This causes a -181 error. The value is formatted
correctly with an update. This behavior occurs even if the variable
is listed on the MAPTO clause and if the variable is formatted in the
SAS data set.
The only workaround is to use some other approach for deleting the
rows.
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#006839
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#006839
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: | medium |
| Topic: | SAS Reference ==> Procedures ==> DB2UTIL
|
| Date Modified: | 2002-09-11 16:56:07 |
| Date Created: | 2002-02-04 12:28:55 |
