Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 4 Types of Action Statements : Categories of Action Statements

Categories of Action Statements
Assignment Statements
Use assignment statements to assign values to fields or to local variables. There are two kinds of assignment statements:
The rules language uses the equal sign (=) as the assignment operator. Refer to Assignment Operator, for additional information about assignment statements.
Database Synchronization Statements
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
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
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:
Rules Invocation Statements
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:
Table Access Statements
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:
Behavior of Rules when Using Table Access Statements
Using table access statements, rules do the following:
Enter new information into the table by first placing the new data in the appropriate fields of a table buffer and then executing either a REPLACE or an INSERT statement.
Selecting Data
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:
FORALL EMPLOYEES WHERE REGION = 'MIDWEST':
is the same as
FORALL EMPLOYEES('MIDWEST'):

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved