DB2 FOR LUW / DB2FORLUW / A50 - DB2

With V9.7 client, when importing data to a table with TIMESTAMP 
column(s) in V9.5 or earlier database, if the timestampformat 
file type modifier is specified for ASC/DEL file, IMPORT might 
hit SQL0304N error when attempting to import rows containing 
TIMESTAMP data, and then reject the rows. 
 
You can see the following messages when the issue occurs: 
 
SQL3148W  A row from the input file was not inserted into the 
table.  SQLCODE "-304" was returned. 
 
SQL0304N  A value cannot be assigned to a host variable because 
the value is not within the range of the host variable's data 
type.  SQLSTATE=22003

**************************************************************** 
* USERS AFFECTED:                                              * 
* When importing data to a table with TIMESTAMP column(s) in   * 
* V9.5 or earlier database.                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v10.5 FP3.                                        * 
****************************************************************

Try to remove the timestampformat file type modifier from the 
IMPORT command and import again when TIMESTAMP data is well 
formatted in the ASC/DEL file.

DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
 DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
 

The problem is firstly fixed on v10.5 FP3.

not known / see Local fix

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

07.03.2014
15.09.2014
15.09.2014