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


Chapter 5 Editing a Table Definition : Deleting a Definition

Deleting a Definition
There are a number of methods that you can use to delete a table definition. Refer to the following table to determine the appropriate method to use:
Promotion system for that location.
Considerations when Deleting an Object
If an object such as a table definition was promoted to another (target) system, you must submit a change request through the Promotion system (of the source system) to extend the deletion to the target system. If you do not issue a change request to delete the definition, the following occurs:
If a new object with the same name is created on the source system, the creator is unable to promote the object to the target system because an object with the same name already exists there.
Deleting a Definition Using the Table Definer
When you are within an existing definition in the Table Definer, you can delete a definition by doing one of the following:
Use the DELETE command.
In either case you are prompted to confirm the deletion.
Deleting a Definition Using a Shareable Tool
The shareable tool DELETE_DEFN is available to you to delete existing definitions. Using this tool, if the correct security access is set up, you can delete definitions across TIBCO Object Service Broker nodes or within your local node. DELETE_DEFN is called from within a rule.
Example Rule
The following rule calls the DELETE_DEFN tool to delete the definition of the DEPARTMENTS table from Node A. Because a table definition is being deleted, values are not required for the arguments library, environment, or parentonly:

 
DELETE_TABLEDEFN;
_
_ ---------------------------------------------------------------------------
_ ------------------------------------------------------------+--------------
_ CALL DELETE_DEFN(’TABLE’, ’DEPARTMENTS’, ’’, ’’ , ’NODEA’, | 1
_ ’’); |
_---------------------------------------------------------------------------

 
See Also
TIBCO Object Service Broker Shareable Tools for information about the tools.
TIBCO Object Service Broker Managing Deployment for information about change requests.

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