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


Chapter 3 Tools : SIXDELETE

SIXDELETE
Deletes an existing secondary index. (CE)
Invocation
Do one of the following:
Type CALL SIXDELETE(table, secondary_key)
Where:
 
Usage Notes
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.
Using SIXDELETE from the Administrator’s Workbench
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.
See Also
TIBCO Object Service Broker Application Administion for information about secondary indexes.

Exceptions
 
Example
The following statement deletes the secondary index on the table EMPLOYEE:

 
RULE EDITOR ===> SCROLL: P
SIXDELETE_1;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ CALL SIXDELETE('EMPLOYEE', 'MGR#'); | 1
_ ---------------------------------------------------------------------------

 
Table Definition Changes
Executing the rule causes the following change to be made to the table definition:

 
COMMAND==> TABLE DEFINITION
 
Table: EMPLOYEE Type: TDS Unit:USR40 IDgen: N
 
Parameter Name Typ Syn Len Dec Reference ' Event Rule Typ Acc
---------------- - - --- -- ---------------- ' ---------------- - -
_ ' _
_ ' _
Field Name Typ Syn Len Dec Key Ord Rqd Default Reference
---------------- - - ---- -- - - - ---------------- ----------------
_ EMPNO I P 3 0 P
_ LNAME S C 22 0
_ POSITION S C 14 0
_ MGR# I P 3 0
_ DEPTNO I B 2 0
_ SALARY Q P 3 2
_ HIREDATE D B 4 0
_ ADDRESS S V 38 0
_ CITY S C 20 0
_ PROV S C 3 0
_ P_CODE S C 7 0
_
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 
It returns the following to the ENDMSG:
THE RETURN CODE IS 0.

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