![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The selection criteria. Its syntax can be C (fixed-length character string), V (variable-length character string), or UN (Unicode).
• COUNTOCCURRENCES can be used for TDS, parameter (PRM), temporary (TEM), calculation (CLC), session (SES) tables, and Execution Environment (EES) tables.
• You can base the selection criteria on any field of the table. For optimum performance, base the selection on a secondary index field.The following rule returns the number of employees who work for a regional company. The EMPLOYEE_REGION table is parameterized by region and MGR# is a secondary index field.
If you executed this rule from the workbench and passed in the values of MIDWEST for the argument AREA and 56112 for the MGR#, the following result is returned at the bottom of your screen:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |