recovery when using sql tables
Recovery or rollback procedure when using SQL tables on AS400
Software/Hardware used:
Software/Hardware used:
ASKED:
July 7, 2009 1:34 PM
UPDATED:
July 7, 2009 8:38 PM
Answer Wiki:
SQL tables are generally journalled.
Use DSPFD to make certain this is the case and the journal names.
Recovery is no different than other AS/400 files.
Commitment control level is set in SQL
At the end of process an SQL commit or Rollback should be sent.
Phil
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
