![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
CALL FORALLE(table)
Name of a table involved in a previous FORALLA or FORALLB call. Its syntax is C (fixed-length character string) with length of 16.
• There are a maximum of 16 tables that can be actively accessed with FORALLA and FORALLB per transaction. An index is maintained for each table being accessed by FORALLA and FORALLB, and there is a maximum of 16 simultaneous indexes per transaction. FORALLE clears the index for the specified table, and frees up resources for another table to be accessed. When you are finished accessing a table with FORALLA or FORALLB, you should call FORALLE to indicate that you are finished and free up resources for another table to be accessed.The following rule uses FORALLA and FORALLB to retrieve all the occurrences in the MIDWEST parameter instance of the EMPLOYEE table and put them in the message log. FORALLE is used to clean up the table index when the loop exits normally or when an exception is raised. All the exception handlers call FORALLE, so that all ending points for the FORALLA, FORALLB sequence are covered by a FORALLE.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |