JR30058: NETEZZA SOURCE AND TARGET COLUMNS ARE NOT THE SAME

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Enhancement request to support source and target columns that
    are not the same.
    

Local fix

  • Can use ODBC stage
    

Problem summary

  • ****************************************************************
    USERS AFFECTED:
    The customer is not able to Update or Upsert when target table
    schema is different from Input Schema
    ****************************************************************
    PROBLEM DESCRIPTION:
    With the initial design, the requirement that input schema
    should be the same as that of target table schema for high
    performance was made mandatory.
    But now when these two schemas are different , the netezza
    upsert stage is not able to perform.
    ****************************************************************
    RECOMMENDATION:
    by adding new functionality. The patch is made and delivered to
    the customer
    ****************************************************************
    

Problem conclusion

  • Mismatch of input and target table Schemas is not allowing to
    upsert or update.
    

Temporary fix

Comments

  • This change is included in 8.0.1 Fix Pack 2.
    

APAR Information

  • APAR number

    JR30058

  • Reported component name

    WIS DATASTAGE

  • Reported component ID

    5724Q36DS

  • Reported release

    801

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-07-30

  • Closed date

    2008-10-24

  • Last modified date

    2009-07-06

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

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

Modules/Macros

  • SERVER
    

Fix information

  • Fixed component name

    WIS DATASTAGE

  • Fixed component ID

    5724Q36DS

Applicable component levels

  • R801 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

InfoSphere DataStage

Software version:

8.0.1

Reference #:

JR30058

Modified date:

2009-07-06

Translate my page

Machine Translation

Content navigation