AUTO_COMMIT

Read syntax diagramSkip visual syntax diagram
                .-0-.   
>>-AUTO_COMMIT=-+-n-+------------------------------------------><

AUTO_COMMIT
Specifies a value for the editor Auto commit (Changes) option that is to apply to all users accessing the Db2® subsystem specified in the SSID parameter. Allowable values are in the range 0 - 10000.

The default is 0, meaning that every ZDT/Db2 editor user can change the value for the Auto commit (Changes) option using the Editor Options (6 of 8) panel. Allowable values are in the range 0 - 2147483647.

Specify a positive value (n) to:
  • Set the Auto commit (Changes) value for every ZDT/Db2 editor user to the specified value. The value appears on the Editor Options (6 of 8) panel as a protected field.
  • Remove the ability of each ZDT/Db2 editor user to change the value for the Auto commit (Changes) option.