Database synchronization statements can be used to synchronize the data in the database after changes are made to it. For more information about synchronization, refer to
Establishing Synchronization Points. Refer to the following topics for a full description of each database synchronization statement and an example of its usage:
Looping statements allow repetitive processes to take place. Refer to the following topics for a full description of each looping statement and an example of its usage:
Output statements present data to a screen or print reports. Refer to the following topics for a full description of each output statement and an example of its usage:
A rule can invoke another rule as a function through a logical or arithmetic expression, or as a procedure with a CALL statement. A functional rule returns a value that can be used as an operand in a rules statement. You can use a functional rule anywhere you can use an expression. A procedural rule is called from within another rule to perform actions that do not return a value. Refer to the following topics for a full description of each rules invocation statement and an example of its usage:
Rules use table access statements to retrieve and manipulate data in the tables. When a rule refers to a table, a table buffer is created, which serves as a workspace for the table. Refer to the following topics for a full description of each output statement and an example of its usage:
To qualify the selection of occurrences, use the WHERE clause. You can also use the WHERE clause to select the table instances of a parameterized table, or you can specify the table instance in parentheses () after the table name. For example: