Example: Obtain the Number of Logically Deleted Rows From a Load Operation
SELECT WITH DELETED ROWS COUNT(*) FROM ldi_table
WHERE (TD_ROWLOADID/'100000000'xi8)(int) = load_id_value;
SELECT WITH DELETED ROWS COUNT(*) FROM ldi_table
WHERE (TD_ROWLOADID/'100000000'xi8)(int) = load_id_value;