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


Chapter 3 Tools : CLEARTABLE_APPL

CLEARTABLE_APPL
Deletes occurrences from a table or table instance. (E)
Invocation
Do one of the following:
Type table[, select] <Enter>
Type CLEARTABLE_APPL <Enter>. The prompt screen appears.
Type EX CLEARTABLE_APPL <Enter>. The prompt screen appears.
Where:
 
Usage Notes
CLEARTABLE_APPL deletes occurrences from a single table or table instance. To clear occurrences from a set of table instances, use the $CLRTAB rule.
Using CLEARTABLE_APPL From the Workbench
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:
CL Clear Table ==> EMPLOYEES(MIDWEST),
To delete selected occurrences, type the name of the table, the parameter if applicable, a comma, and a selection string. For example:
 
CL Clear Table ==> EMPLOYEES(MIDWEST),NUM>2
 
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.
Using CLEARTABLE_APPL from the Prompt Screen
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:
Table Name ==> EMPLOYEES(MIDWEST)
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:

 
                     Rule Execute Utility CLEAR TABLE
 
 
 
Table Name ===> EMPLOYEES(MIDWEST)
 
 
Select Occurrences Where
===> LNAME='Smith'

 
Example
The following example uses the CL Clear Table option to remove all occurrences in EMPLOYEE_DEPT(10):
CL Clear Table ==> 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:

 
                     Rule Execute Utility CLEAR TABLE
 
 
 
Table Name ===> EMPLOYEE
 
 
Select Occurrences Where
===> deptno>=20

 

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