IBM Support

JR32828: ORACLE CONVENTIONAL LOAD SHOULD ALLOW TRIGGER TO RESOLVE NOT NUL

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer want to use oracle trigger to fill in not null column,
    which means DataStage does not need to provide any value.
    Current software functionality checks that all not null columns
    exist and this is not desirable.  Customer is using conventional
    path load which fires trigger.  Could use upsert or ODBC but
    those do not allow open/close commands.
    

Local fix

  • use upsert to insert data or ODBC stage.
    
    This fix is included in 8.0.1 fix pack 3
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    none. minor enhancement.
    ****************************************************************
    PROBLEM DESCRIPTION:
    Customer want to use oracle trigger to fill in not null column,
    which means DataStage does not need to provide any value.
    Current software functionality checks that all not null columns
    exist and this is not desirable.  Customer is using
    conventionalpath load which fires trigger. Could use upsert or
    ODBC but     those do not allow open/close commands.
    ****************************************************************
    RECOMMENDATION:
    apply patch provided.
    This change is included in 8.1 Fix Pack 1.
    ****************************************************************
    

Problem conclusion

  • Enhanced load method. Now it does not warn or error if a column
    with NOT NULL column is not loaded values from DS. Loader
    sessions fail unless the column has a default value or is
    handled specially by an before-insert trigger. Load will be in
    conventional  path facilitate user in these cases.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32828

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-04-29

  • Closed date

    2009-05-15

  • Last modified date

    2010-12-09

  • 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

  • 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:
09 December 2010