DB2 FOR LUW / DB2FORLUW / 980 - DB2

The following LOAD command fails with SQL0180 on valid 
TIMESTAMP values in the LOAD file: 
db2 "LOAD FROM t1.asc OF ASC METHOD L (1 19) INSERT INTO t1" 
 
Where table t1 contains one TIMESTAMP column: 
db2 "CREATE TABLE t1 (c1 TIMESTAMP)" 
 
And LOAD file t1.asc contains valid TIMESTAMP values on each 
row: 
2010-03-04-10.05.00 
...

USERS AFFETCED: 
All 
 
PROBLEM DESCRIPTION: 
See ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
See ERROR DESCRIPTION

* Use delimited ASCII file format for the LOAD file 
* Add MODIFIED BY TIMESTAMPFORMAT="YYYY-MM-DD-HH.MM.SS" to the 
  LOAD command 
* Pad the timstamp values in the LOAD file with blanks up tp the 
  form "YYYY-MM-DD-HH.MM.SS.UUUUUU", and modify the METHOD L 
  byte offsets accordingly

DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.8 Fix Pack 4 for AIX and Linux
 DB2 Version 9.8 Fix Pack 5 for AIX and Linux
 

Problem was first fixed in Version 9.8 Fix Pack 3.

See LOCAL FIX.

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

12.03.2010
30.12.2010
30.12.2010

9.8.FP3