JR34162: FOR NETEZZA, ALLOW THE UPSERT METHOD TO DELETE DATA IN THE TARGET TABLE, LIKE SIMLIAR STAGE IS DOING, I.E. DB2, ODBC...

Download Fix Pack 2 for InfoSphere Information Server Version 8.1

APAR status

• Closed as fixed if next.

Error description

• For Netezza, allow the upsert method to delete data in the
  target table, like simliar stage is doing, i.e. DB2, ODBC...
  
  Currently when we want to delete data, we load data into a
  temporary table, the we trigger a SQL delete statement from the
  "close command" parameters in the Netezza stage. This could be
  done in a similar way as the update method provided by the
  stage.
  
  This is an enhancement request.
  

Local fix

• This fix is included in 8.0.1 fix pack 3
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  IS 8.0.1.1 Netezza Stage
  ****************************************************************
  PROBLEM DESCRIPTION:
  FOR NETEZZA, ALLOW THE UPSERT METHOD TO DELETE DATA IN THE
  TARGET TABLE, LIKE SIMLIAR STAGE IS DOING, I.E. DB2, ODBC...
  ****************************************************************
  RECOMMENDATION:
  The Enhancement is completed and delivered as a patch.
  This patch has both GUI changes and code changes.
  Please apply the patch for the new functionality.
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

• NETEZZA
  

Fix information

Applicable component levels

• R801 PSY

     UP