JR61935: DB2 CONNECTOR DOES NOT SUPPORT EXTERNAL TABLES IN USER-DEFINED SQL WRITE MODE

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 new function.

Error description

• DB2 Connector supports external tables in all write modes only
  with generated SQL statements. There is no way to use custom
  SQL statements together with external tables or temporary work
  table, not even in Write mode User-defined SQL.
  

Local fix

• n/A
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  DB2 Connector users who want to use external tables with custom
  SQL statements in User-defined SQL write mode
  ****************************************************************
  ****************************************************************
  PROBLEM DESCRIPTION:
  DB2 Connector supports external tables in all write modes only
  with automatically generated SQL statements. There is no way to
  use custom SQL statements together with external tables or
  temporary work table, not even in User-defined SQL write mode.
  ****************************************************************
  RECOMMENDATION
  apply patch for JR61935
  ****************************************************************
  

Problem conclusion

• Add support for external tables and temporary work table in DB2
  Connector's User-defined SQL Write mode.
  Write using external tables implies the use of temporary work
  table. The connector introduces two place holders (parameters)
  that can be used in the custom User-defined SQL to refer to the
  temporary work table (TWT) and the target table:
  [[twt]] - temporary work table name
  [[table]] - target table name
  The use of placeholders is crucial in automatic temporary work
  table mode, where the TWT name is not known in advance. The
  place holders will be replaced with actual names at run time.
  Examples of user-defined SQL statements using the place holders:
  INSERT INTO [[table]] SELECT * FROM [[twt]]
  UPDATE [[table]] SET [[table]].col1 = [[twt]].col1
  

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

• RB71 PSY

     UP