JR31903: IFXBULKCOPY REPORTS SYNTAX ERROR WHEN EXECUTED WITHIN TRANSACTIONSCOPE

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

APAR status

• Closed as program error.

Error description

• Using IfxBulkCopy to copy rows from a data source to a table in
  a database within MSDTC transaction will report the following
  error
  
  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)
  

Local fix

• Start Informix Dynamic Server with environment variable
  DELIMIDENT=Y if possible.
  

Problem summary

• # Users Affected:
  Running Data Server Driver against Informix Dynamic Server
  
  # Problem Description:
  
  IFXBULKCOPY REPORTS SYNTAX ERROR WHEN EXECUTED WITHIN
  TRANSACTIONSCOPE
  
  Using IfxBulkCopy to copy rows from a data source to a table in
  a database within MSDTC transaction will report the following
  error
  
  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)
  
  
  # Problem Summary:
  
  When using IfxBulkCopy against Informix Dynamic Server to copy
  rows from a data source to a table in a database within MSDTC
  transaction will report the following error
  
  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)
  

Problem conclusion

• Problem was first fixed in Version 9.5 Fix Pack 4
  

Temporary fix

• Start Informix Dynamic Server with environment variable
  DELIMIDENT=Y if possible.
  

Comments

APAR Information

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

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

Fix information

• Fixed component name

  DB2 UDB ESE WIN

• Fixed component ID

  5765F4101

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP