IBM Support

JR32965: MS OLEDB PLUGIN - GENERATED SQL INCORRECT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as fixed if next.

Error description

  • MS OLEDB plugin - Generated SQL incorrect
    
    The statement generated includes values marked as "Keys" in
    the UPDATE clause of the statement as well as in the WHERE
    clause.  For example, given an MS OLEDB stage with columns
    TaskID (Key=Yes),
    EndTime (Key=No), Status (Key=No), and Description (Key=No).
    The generated SQL is:
    UPDATE TaskLog SET TaskID=?,EndTime=?,Status=?,Description=?
    WHERE
    TaskID=?;  This fails because (as is often the case in SQL
    Server), the TaskID is
    an identity column and cannot be updated.  The generated SQL
    should NOT
    include the Key columns in the UPDATE clause.
    

Local fix

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    user who uses msoledb stage with update action and generated
    sqlwith IS81
    ****************************************************************
    PROBLEM DESCRIPTION:
    when there's a key field in the column, that key field should
    not be included in the update action with generated sql
    ****************************************************************
    RECOMMENDATION:
    install patch for JR32965
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • fixed in 8.1 Fix Pack 1.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32965

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-13

  • Closed date

    2009-12-15

  • Last modified date

    2009-12-15

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

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

Modules/Macros

  • MSOLEDB
    

Fix information

Applicable component levels

  • R801 PSN

       UP

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

Document Information

Modified date:
15 December 2009