IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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 number

    JR61935

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    B71

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-01-28

  • Closed date

    2020-02-17

  • Last modified date

    2020-02-17

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 October 2021