>>>>>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.
DB2 does record a variety of logs used for recovery (WADS, ODS etc), both for forward (old backup with changes applied) and backward (same with reverse transactions) but the logs are not available to anyone except the recovery procedures and the tables (an in somecases the database(s)) need to be offline. The VFP/Fox concept of 'pending' deletion has been a desire of IBM mainframe programmers for a long time. You would need to build you own log file but would only be seeing you actions, not other users of the DB2 tables.
Sorry.
HTH