![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Developer’s workbench Press <Enter>. The prompt screen appears. Type CLEARTABLE_APPL <Enter>. The prompt screen appears. Type EX CLEARTABLE_APPL <Enter>. The prompt screen appears.
[Optional] Selection string consisting of a field name, a relational operator, and a valueCLEARTABLE_APPL deletes occurrences from a single table or table instance. To clear occurrences from a set of table instances, use the $CLRTAB rule.
• To delete all occurrences in a non-parameterized table or a table instance, type the name of the table, the parameter if applicable, and a comma. For example:
• To delete selected occurrences, type the name of the table, the parameter if applicable, a comma, and a selection string. For example:
When invoking CLEARTABLE_APPL from the workbench, the selection string must be based on a field that contains numeric rather than alphabetic data. To select on alphabetic data, execute CLEARTABLE_APPL from the prompt screen and refer to the following section.
• To delete all occurrences within a non-parameterized table or a table instance, type the name of the table and the parameter if applicable in the Table Name field and press Enter. For example:
• To delete selected occurrences, type the name of the table and the parameter if applicable in the Table Name field, and then type a selection string in the Select Occurrences Where field. For example, to delete all employees named Smith from EMPLOYEES(MIDWEST), type the following:
The following example uses the CL Clear Table option to remove all occurrences in EMPLOYEE_DEPT(10):Using the prompt screen, the following entries remove all occurrences in the non-parameterized table EMPLOYEE that have the field DEPTNO equal to or greater than 20:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |