Normally, SQL-PL implicitly terminates the current transaction (COMMIT) before each READ and FORM call. With the module option AUTOCOMMIT OFF, the program developer has the possibility of controlling the transactions explicitly. A further effect of the option AUTOCOMMIT OFF is that the database return code 700 (SESSION INACTIVITY TIMEOUT) has to be handled in the SQL-PL routine. If this error occurs, the database connection is established again by SQL-PL and the statements of this transaction must be repeated by the SQL-PL routine.
Thus transactions can be programmed in which the user is asked questions. There is, however, the danger that other users are blocked by holding database locks for a long time.
The module options are only valid for the execution of the routine in which they are contained, not for modules that are called by it. Both options can be specified:
Syntax:
