SU Profile Commands for COMMIT and ROLLBACK

Two commands are available for use in the SU profile that enable the FOCUS Database Server administrator to control whether COMMIT processing is allowed and how the server checks for currency errors. (The SU Profile is discussed in Using the SU Profile.)

Syntax: How to Control COMMIT Processing on the FOCUS Database Server

By default, the FOCUS Database Server accepts source users whose MODIFY or Maintain procedures include the COMMIT and ROLLBACK subcommands. The following command in the SU Profile controls whether the server accepts these procedures.

SET COMMIT = {ON|OFF}

where:

ON: Causes the server to accept MODIFY and Maintain procedures that issue COMMIT and ROLLBACK commands or that set COMMIT ON. ON is the default value. Maintain procedures require SET COMMIT = ON.
OFF: Causes the server to reject procedures that either issue COMMIT and ROLLBACK commands or set COMMIT ON.

Syntax: How to Control Currency Checking on the FOCUS Database Server

The server, by default, determines the value of FOCURRENT by checking the segment that was updated and all of the parent segments in the path. If any segment in a path was changed between the time a source user retrieved the record and the time the user issues a COMMIT, FOCURRENT has a non-zero value and the COMMIT fails.

This default can be changed for the server with the SET PATHCHECK command so that only the updated segment is checked. Syntax for the SET PATHCHECK command, which is placed in the SU profile, is

SET PATHCHECK = {ON|OFF}

where:

ON: Checks parent segments as well as the updated segment to determine the value of FOCURRENT. Occurs for all source users. ON is the default value.
OFF: Checks only the updated segment to determine the value of FOCURRENT. Applies to all source users.