SU Profile Commands for COMMIT and ROLLBACK

In this section: Controlling COMMIT Processing on the Sink Machine Controlling Currency Checking on the Sink Machine

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

Controlling COMMIT Processing on the Sink Machine

The sink machine, by default, accepts source users whose MODIFY or Maintain procedures include the COMMIT and ROLLBACK subcommands. The following command in the SU Profile controls whether the sink machine accepts these procedures.

SET COMMIT = {ON|OFF}

where:

ON

Causes the sink machine to accept MODIFY and Maintain procedures that issue COMMIT and ROLLBACK commands or that set COMMIT ON. ON is the default value.

OFF

Causes the sink machine to reject procedures that either issue COMMIT and ROLLBACK commands or set COMMIT ON.

Controlling Currency Checking on the Sink Machine

The sink machine, 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 has been changed between the time a source user retrieved the record and the time the user issues a COMMIT, FOCURRENT will have a non-zero value and the COMMIT will fail.

This default can be changed for the sink 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.