DB2 CONNECT / DB2CONNCT / 970 - DB2

If the columns in the data source and in the target table don't 
match and we don't use column mapping we will get a syntax error 
when the target table contains a SERIAL column. 
 
 
ERROR [42000] [IBM][IDS/UNIX64] A syntax error has occurred. 
   at IBM.Data.Informix.IfxBulkCopy.WriteToServer() 
   at IBM.Data.Informix.IfxBulkCopy.WriteToServer(IDataReader 
dataReader) 
   at ConsoleApplication1.Program.Main(String[] args) 
 
onstat -g ses shows: 
 
Current SQL statement : 
  INSERT INTO "informix"."instarget" ( "id" ) VALUES ( default ) 
 
The error disppears when the SERIAL is changed to INTEGER.

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users using BulkCopy and when the source has only one        * 
* selected column and the destination table has a SERIAL       * 
* column as the first column among the other columns in the    * 
* destination table                                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* If the BulkCopy involves the source having only one column   * 
* and the BulkCopy is to the destination table with n column   * 
* with one of them being a SERIAL column as the first column,  * 
* this error occurs.                                           * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v97fp2 or later release                           * 
****************************************************************

N/A

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 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
 

The generated 'Insert' statement internally would have syntax 
errors. Need to ensure that this does not happen

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC66631 
Nachfolger : 

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

24.06.2009
14.05.2010
14.05.2010

9.7.FP2