Committing Database Variables

A DO COMMIT statement sets commitment options for writing the variable value back to the Control-M/Analyzer Database and unlocks the variable – making it available to other rules. Various methods are available for specifying the type of commit that should occur. For information about DO COMMIT options and the DO SET statement, see Rule Definition.

Examples

When defining rules, the user should take into account various variable locking and unlocking methods. Examples of locking and committing strategies include:

• To lock a variable throughout the processing of the current rule until the new value is stored in the Database: Initialize the variable to itself at the beginning of the rule and commit the variable at the end of the rule.

  Table 136 Committing Database Variables – Example 1

  Do Statements	Database Variable Status
  DO SET = DB_TOTAL=DB_TOTAL	Locked
  ...	Locked – while processing
  DO COMMIT ALL	Unlocked – new value written

Note: In the example above, if the DO COMMIT statement is omitted, the DB_TOTAL variable is automatically committed and unlocked during rule termination.

• To exclusively perform calculations on a variable without storing the result in the Database: Use a DO COMMIT statement with the DELETE option. No variables are committed (written) but the DO COMMIT statement unlocks the variable.

  Table 137 Committing Database Variables – Example 2

  Do Statements	Database Variable Status
  DO SET = DB_TOTAL=DB_TOTAL	Locked
  ...	Locked – while processing
  DO COMMIT DELETE	Unlocked – new value is not written

• To access and process a variable without restricting its use by other rules, write the value of the new variable to the Database after the new value has been calculated.

  Table 138 Committing Database Variables – Example 3

  Do Statements	Database Variable Status
  DO SET = TEMP=DB_TOTAL	Unlocked
  ...	Unlocked – while processing
  DO SET = DB_TOTAL=TEMP	Locked
  DO COMMIT ALL	Unlocked – new value is written

• To create a new Database variable, no locking or committing is necessary.

  Table 139 Committing Database Variables – Example 4

  Do Statements	Database Variable Status
  DO SET = DB_TOTAL=DB_TOTAL	Unlocked
  ...	Unlocked – while processing