I am calling the Netezza Store procedure inside the Netezza Dbrow component. Inside the store procedure, I do Insert and Update, for Audit purpose I need to log how many records are getting inserted and updated. unfourtenetly Netezza Dbrow component having NB_LINE_EFFECTED, So I could not able to capture the Insert and update row count separately and ROWCOUNT features are also not available in Netezza.
Could you please advise how to handle this situation.
If Netezza is not having the rowcount feature, one another idea will be to do a left outer join count between input data and target table to measure the number of matched records based on key columns. All the records with match will have ids of target table and all new records will have blank in this field.
If you can count the number of records with non blank and blank fields and store it into another table, then you can use them later. Please note that the count needs to be taken before actual insert. Else all the records will be classified as updates.
I hope I have answered your query. Could you please mark the topic as resolved for future reference by community members? Kudos are also welcome 🙂
