![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The value for the first data parameter of tablename. The value for the second data parameter of tablename. The value for the third data parameter of tablename. The value for the fourth data parameter of tablename.
• $CLRTAB is a replacement for the CLRTAB tool. CLRTAB exists for backward compatibility only.
• Because $CLRTAB does not take part in the TIBCO Object Service Broker two-phase commit protocol, it does not clear the intent list. It affects only the information in the specified table. Therefore, if you use $CLRTAB in a transaction that also updates data within the cleared table, you can get the following, possibly undesired, result: occurrences previously in the intent list are saved to the table at the next commit after the clearing of the table.
• $CLRTAB does not clear the current-occurrence buffer. It affects only the information in the specified table. For example, if you do the following:
b. the other fields of the inserted occurrence still contain the values you assigned. If you intend that the table be empty except for your newly assigned value, run $CLRTAB as a separate transaction followed by the update.
• If called from within a transaction in BROWSE mode, $CLRTAB clears TEM, SES, EES, and SCR tables; it does not clear TDS or DB2 tables.
• If the table is parameterized, the number of data parameter values supplied must equal the number of data parameters in the table definition. For example, if the table has fewer than four data parameters, type two single quotation marks ('') for each argument that is not required. If the quotation marks are not included for the excess arguments, the transaction fails with a ROUTINEFAIL exception.
• $CLRTAB ignores location parameters. In case of minimal table definition, $CLRTAB does nothing.
• The parameter values supplied must be convertible to the syntax of the parameter definitions.
• To delete a specific table instance, specify its parameter values in the arguments parm1, parm2, parm3, and parm4.
• To delete all the data in a parameterized table, specify a set of single quotation marks ('') for each of the arguments parm1, parm2, parm3, and parm4.
• CLEARTABLE_APPL, which you can use from the CL clear table option on the standard workbench, can also be used to clear table data. This interactive tool reads and deletes each table row.
If $CLRTAB fails, you must run it again before doing another database update to prevent damage to the database. If $CLRTAB fails again, contact your database administrator or TIBCO Support immediately.
Raised if any argument fails validation, that is, for conversion errors or incorrect table typeIt is also raised if, when clearing an instance of a table that has multiple data parameters, some of the data parameters for the instance are missing as arguments.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |