A fix is available
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 number
JR34162
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-09-01
Closed date
2009-09-16
Last modified date
2010-12-10
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"InfoSphere DataStage"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021