>>>>Can you still view the deleted records? What I am trying to get at is the SQL delete/insert option viable for true SQL /ODBC type tables?
>>>
>>>I am fairly certain you can not still view deleted records id DB2; You definitely can not view deleted records in Oracle. The only thing you can do in Oracle is *COMMIT* the delete or *ROLLBACK* the deletion. Rollback cancels the delete and everything else since the last *COMMIT*. That may be spelled COMIT. One spelling denotes a celestial phenomenon as in Haley's or Hale-Bop.
>>So there is no way to view "old" records to see what changes to what fields were made (i.e a change log) using DB2?
>
>Not that I know of.
I guess you could parse the fields and save the field name, change date, user, oldval, newval, etc to a separate table before saving.