IBM Support

IC67555: SHAPEFILE IMPORT AFTER SHAPEFILE EXPORT OF TIME AND TIMESTAMP VALUES FAILS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error 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 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.
    

Local fix

  • 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.
    

Problem summary

  • ****************************************************************
    * 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                                          *
    ****************************************************************
    

Problem conclusion

  • Upgrade to V9.7 FP3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC67555

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-03-30

  • Closed date

    2010-09-16

  • Last modified date

    2010-09-16

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC69127

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 September 2010