When the Ignore commitment control checkbox in the 3GL Generation tab of the environment attribute screen is not checked, SQL databases always run in commitment control mode. As a result, you must use a COMMIT instruction in your programs so that any modifications to the database may be validated at the end of the application.
The COMMIT instruction can also be used to unlock modified records during a work session.
When the Ignore commitment control checkbox in the 3GL Generation tab of the attributes screen is checked, SQL databases run without commitment control. As a result, updates are automatically validated and the COMMIT and ROLL_BACK instructions will be ignored.
The way this mode is taken into account depends on whether you work with an AS/400 database or a PC database (DB2 for Windows, Oracle, SQL Server):
For AS/400 databases, Adelia will specify if the "Ignore commitment control" checkbox has been checked or not when compiling the AS/400 server module (*NONE or *CHG value of the COMMIT parameter for the CRTSQLRPGI command); the information is then found in the IBM object.
Therefore, if the mode changes, for the same work session, some programs will run in commitment control mode and others without commitment control.For PC databases, specify the commitment control mode when connecting to the database. Adelia will take into account the state of the "Ignore commitment control" checkbox when it generates in the program the code to connect to a database. However, even though it is possible for all the programs to connect to a database, only the first program running the code in the server block of a work session actually runs the connection procedure. The other programs in the session will use the same connection. Therefore, if the mode changes, all the accesses to the database of the work session programs will take place in commitment control mode or without commitment control, depending if the "Ignore commitment control" checkbox has been checked or not when generating/compiling the first application program.
Concerning Adelia Web programs (WADELIA) with connection conservation, the execution mode (with or without commitment control) corresponds to the specified value in the client configuration file (MWCLIENT.INI) association.
PC databases are always created with their logs.
This is not always true in the case of AS/400 databases.