JR61313: DB2 CONNECTOR DOES NOT DROP UNMATCHED COLUMNS WHEN USING RCP WITH DIRECT INSERT = NO

IBM InfoSphere Information Server, Version 11.7.1.1 (Fix Pack 1)
IBM InfoSphere Information Server, Version 11.7.1.1 for AIX
IBM InfoSphere Information Server, Version 11.7.1.1 for Windows
IBM InfoSphere Information Server, Version 11.7.1.1 for Linux

APAR status

• Closed as program error.

Error description

• DB2 connector does not drop unmatched columns when using RCP
  with Direct insert = no
  

Local fix

• no
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 connector users
  ****************************************************************
  PROBLEM DESCRIPTION:
  When writing data to DB2 with 'Direct insert' set to 'No' and
  'Drop unmatched columns' set to 'Yes', DB2 connector fails with
  the following error:
  
  ##E IIS-CONN-DB2-00695 13:06:01(352) <DB2_Target>
  SQLExecDirect() reported: SQLSTATE = 42S22: Native Error Code =
  -206: Msg = [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N "COL_X"
  is not valid in the context where it is used. SQLSTATE=42703
  (CC_DB2Adapter::postRun, file CC_DB2Adapter.cpp, line 885)
  ****************************************************************
  RECOMMENDATION
  Install patch JR61313
  ****************************************************************
  

Problem conclusion

• DB2 connector code has been corrected to properly handle
  unmatched columns when 'Drop unmatched columns' is set to 'Yes'
  and 'Direct insert' is set to 'No'.
  

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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• RB70 PSY

     UP

• RB71 PSY

     UP