>>>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.