IT41949: THE DESCRIPTION OF A DATABASE PARAMETER IS INCORRECT FOR A PARAMETER MARKER THAT FOLLOWS AN INCREMENTED COLUMN

APAR status

• Closed as change to accomodate OEM Vendor's code.

Error description

• The actual values in the error message will depend on the type
  of the database column being describe after the incremented
  column.
  For example
  DatabaseException BIP2322E: Database error: SQL State ''07006'';
  Native Error Code '0'; Error Text ''[IBM][ODBC Oracle Wire
  Protocol driver]Unable to convert parameter 1. Cannot convert
  from C type 93 to SQL type 3.''.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM Integration Bus Version 10 or App Connect
  Enterprise Version 11 or Version 12 who use an Oracle database
  where an incremented column is used in a database statement.
  
  
  Platforms affected:
  AIX, HP-UX PA-RISC platform, HP-UX Itanium platform, Linux on
  Power platform, Linux on x86-64 platform, Linux on zSeries
  platform, Solaris x86-64 platform, Solaris SPARC platform,
  Windows on x86-64 platform
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The DataDirect Oracle ODBC driver incorrectly described the
  columns that followed an incremented column in a database
  statement.
  
  For example in this update statement the database column
  'MyColumn3' would be incorrectly described.
  UPDATE Database.MyTable AS Z
        SET MyColumn1 = CURRENT_TIMESTAMP,
               MyColumn2 = Z.MyColumn2 + 1,
               MyColumn3 = MyNameVariable;
  

Problem conclusion

• A new DataDirect Oracle ODBC driver that fixes the error is now
  supplied with App Connect Enterprise.
  

Temporary fix

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

Applicable component levels