SQL provides the ability to retrieve the entire table of modified data following an insert/update/delete operation.
For insert and update operations, you can use a syntax like this:
SELECT * FROM NEW TABLE (INSERT INTO SCHEMA.TABLE_NAME (UNIQUEID, NAME, DESCRIPTION)
VALUES ((SELECT MAX(UNIQUEID)+1 FROM SCHEMA.TABLE_NAME), ?, ?))
For delete operations, you can use a syntax like this:
SELECT * FROM OLD TABLE (DELETE FROM SCHEMA.TABLE_NAME WHERE UNIQUEID = ?)
In each case, you will be returned a result set containing all of the modified rows from the insert/update/delete operation.
Note: in the SQL statements above, NEW TABLE and OLD TABLE are SQL keywords.