![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Using the D line command, you can delete multiple occurrences. To use the D line command, complete the following tasks:
2. You can use PF16 to delete one occurrence (where the cursor is positioned) at a time. To use PF16, complete the following tasks:
• The DELETE primary command
• If you decide to cancel the deletion, use any PF key other than PF22. When the deletion is completed the screen re-appears with the updated table.To delete data with a rules statement, use the DELETE statement. This statement requires the primary key to be available, either via a previous GET or FORALL on the table, or by explicit selection of the primary key.You can use the WHERE clause and the primary key value to specify which occurrence to delete (that is, WHERE primary key value =).
To delete data using the workbench, use the CL clear table option. To use this option, complete the following tasks:
2.
3. At the Table Name prompts, type in the table name and parameter values, if the table is parameterized.For example, to delete data from the MIDWEST region of the @EMPLOYEES table, type: @EMPLOYEES(MIDWEST).
4. If selection of data is required, at the Select Occurrences Where prompt, type your selection criteria.
5.
2. Type in the name of the table, and the parameter values if the table is parameterized, followed by a comma (,).For example, to delete data from the MIDWEST region of the @EMPLOYEES table, type: @EMPLOYEES(MIDWEST),
3. A number of shareable tools are available for you to delete data from a table. Use the tools as follows:
• To delete data at either a local or remote location, use DELETE_DATA. You can selectively delete data using this tool.
• To delete data locally, use $CLRTAB. You can do only a selection on parameter values using this tool.
• TIBCO Object Service Broker Shareable Tools for information on the tools.
• TIBCO Object Service Broker Programming in Rules for information about the use of rules and the DELETE statement.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |