![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Administrator’s workbench
• SIXDELETE runs and updates are made even if it is called in a transaction that is running in browse mode.
• SIXBUILD ignores the location parameter of the input table. Minimal table definitions are not allowed.
• The field whose secondary index is deleted has the S, or lowercase s for an incomplete secondary index, deleted from the KEY field of the table definition. If the field is part of a composite primary key, the Q is changed to P.If you use SIXDELETE from the administrator’s workbench, when you press Enter a list of tables appears on the screen. From this screen:
1. Type the line command X beside the table you want to delete the secondary index from and press Enter.
2.
Caution is advised when using SIXDELETE because it does not take part in the TIBCO Object Service Broker two-phase commit/intent list protocol. It is strongly recommended that this tool not be used in a transaction that accesses or updates data within the same table and that it should normally be the only logical unit of work within a transaction. If a user uses this tool on the data of a bound table, the data is updated (the updates take place on the bound copy of the data).
If SIXDELETE fails, you must run it again before running another TIBCO Object Service Broker function, to prevent damage to the database. If SIXDELETE fails again, contact your database administrator or TIBCO Support immediately.TIBCO Object Service Broker Application Administion for information about secondary indexes.
The table definition does not exist or is inconsistent, or is not a TDS table. The table that you want to delete the index from is being used by someone else.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |