Makes permanent all the changes you made to relational and Oracle CODASYL DBMS databases since the most recent COMMIT or ROLLBACK statement or, if you have not performed a COMMIT or ROLLBACK, since the first database READY command. The COMMIT statement does not affect collections; collections are maintained. For Oracle CODASYL DBMS databases, the COMMIT statement performs a COMMIT RETAINING. For relational databases, the COMMIT statement starts a new transaction that gives you a new look at the database. When you have both relational and Oracle CODASYL DBMS databases readied, the COMMIT statement commits all Oracle CODASYL DBMS and relational databases, regardless of whether you made any changes to their data. Domains based on RMS files are not affected by the COMMIT statement. Format COMMIT
1 – Arguments
None.
2 – Examples
The following Oracle CODASYL DBMS example connects an employee named Hill to a part LA36 in the RESPONSIBLE_FOR set. The COMMIT statement makes this change permanent. DTR> FIND E IN EMPLOYEES WITH EMP_LAST_NAME = "HILL" DTR> SELECT 1 DTR> FOR P IN PART WITH PART_DESC = "LA36" CON> CONNECT P TO E.RESPONSIBLE_FOR DTR> COMMIT DTR> The following relational database example stores a record in the relation DEPARTMENTS. The COMMIT statement makes this change permanent: DTR> READY DATABASE PERSONNEL USING DEPARTMENTS WRITE DTR> STORE DEPARTMENTS Enter DEPARTMENT_CODE: SENG Enter DEPARTMENT_NAME: SOFTWARE ENGINEERING Enter MANAGER_ID: 87215 DTR> COMMIT DTR>