DB2 FOR LUW / DB2FORLUW / 970 - DB2

The shapefile specification doesn't include support for TIME or 
TIMESTAMP fields.  When columns of these types are exported to a 
shapefile, the fields are exported as CHAR. 
 
If the user attempts to reload this data into a table with TIME 
and TIMESTAMP fields, it will fail with a message about 
incompatible types. This is an example message: 
GSE2106N  The data type of the column 
"DB2SE_FVT"."TIMETEST"."TIME_FIELD" is ""SYSIBM"."TIME"", which 
does 
not match the expected type ""SYSIBM"."VARCHAR"" for the data to 
be 
imported from file. 
 
We do not document this limitation and it is 
reasonable for the customer to expect that data which our 
utility exports should be importable. 
 
Import of CHAR fields into TIME and TIMESTAMP fields should be 
allowed to avoid this customer problem.  DB2 will do the 
appropriate conversions.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Spatial extender users working with TIME and/or TIMESTAMP    * 
* columns which need to be exported and then imported          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The shapefile specification doesn't include support for TIME * 
* or                                                           * 
* TIMESTAMP fields.  When columns of these types are exported  * 
* to a                                                         * 
* shapefile, the fields are exported as VARCHAR.               * 
*                                                              * 
*                                                              * 
*                                                              * 
* If the user attempts to reload this data into a table with   * 
* TIME                                                         * 
* and TIMESTAMP fields, it will fail with a message about      * 
*                                                              * 
* incompatible types. This is an example message:              * 
* GSE2106N  The data type of the column                        * 
* "DB2SE_FVT"."TIMETEST"."TIME_FIELD" is ""SYSIBM"."TIME"",    * 
* which does                                                   * 
* not match the expected type ""SYSIBM"."VARCHAR"" for the     * 
* data to be                                                   * 
* imported from file.                                          * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to V9.7 FP3                                          * 
****************************************************************

The work around is to create a table like the table to be 
imported into but creating CHAR columns instead of TIME and 
TIMESTAMP colums.  Import into this table and then select from 
this table and import into the desired target table.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Upgrade to V9.7 FP3

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC69127 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

30.03.2010
16.09.2010
16.09.2010

9.7.FP3