![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Provides specific processing for every occurrence in a table that is selected, ordered, or both selected and ordered. (C)
The name of the rule to be called for each occurrence in the table that satisfies the selection/ordering criteria.
• Calls to PROCESS_TABLE can be nested (that is, processrule can call PROCESS_TABLE on a different table).
• The syntax for selection is <field name><relational operator><expression>. For valid expressions, refer to the TIBCO Object Service Broker Programming in Rules manual.
•
• processrule must not be a function and it must not have arguments.
• processrule and its descendant rules must not reference the following local variables: TABLE, SELECTION, ORDERING, PROCESSRULE, and GIVENTABLENAME.
• Typing PROC_EMPLOYEE('SALARY < 500.00') at the EX Execute Rule option on the workbench increases the salaries of all the employees whose salary is less than $500.00 in the table EMPLOYEE_DEPT(10).
• Typing PROC_EMPLOYEE('MGR#=79912') at the EX Execute Rule option on the workbench increases the salaries of all the employees managed by MGR# 79912 in the table EMPLOYEE_DEPT(10).
• Typing PROC_EMPLOYEE('EMP_LNAME LIKE "F*" & MGR# = 80354') at the EX Execute Rule option on the workbench, increases the salaries of all employees whose last name starts with F and who are managed by MGR# 80354 in the table EMPLOYEE_DEPT(10).
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |