Unanswered: Help with java stored procedure and trigger
I'm trying to create a trigger to log the updates from one table to another table,
the trigger must be dynamic, I can't hard-code the field names..
I tried to pass the OLDROW and NEWROW to a java stored procedure but I don't know the type of OLDROW and NEWROW to declare the procedure.
Pass the OLDROW and NEWROW.
The procedure will compare the rows differences and will insert into a log table something like that.
Data on EXAMPLETABLE changed EXEMPLEFIELD -> Old value: xxxxx New Value: yyyyy
evozniak - can you explain how your (or your business) will use the contents of the log table (containing old and new values)?
What kind of reports do you expect from it?
What is your plan when DBAs (or particular tools) need to perform LOAD actions ?
Is there some overlap with the functionality of db2audit ?