Problem Note 6505: PROC DB2UTIL passes incorrect datetime to DB2 when updating a DB2
timestamp column
PROC DB2UTIL may pass an incorrect datetime to DB2 when it updates a
DB2 timestamp column. This problem occurs when the new datetime is
in the month of December. Instead a month of January is passed to DB2,
although the day, year, or time portion appear correct.
For example: if the SAS datetime variable has a value of
01dec1999:10:34:00, the value '1999-01-01-10.34.00' is passed into DB2.
This appears to only occur with datetime values with a month of
December.
The only workaround is to switch from PROC DB2UTIL to some other
means of updating the table, such as using the MODIFY statement in the
DATA step.
A Technical Support hot fix for Release 8.1 TSLEVEL TS1M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/81_sbcs_prod_list.html#006505
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#006505
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: | alert |
| Topic: | SAS Reference ==> Procedures ==> DB2UTIL
|
| Date Modified: | 2002-06-18 09:43:08 |
| Date Created: | 2001-12-14 15:14:53 |
