JR30058: NETEZZA SOURCE AND TARGET COLUMNS ARE NOT THE SAME

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 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