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


Chapter 6 Manipulating Data in a Table : Data Manipulation Tools

Data Manipulation Tools
TIBCO Object Service Broker UI
This chapter describes how to perform various tasks in TIBCO Object Service Broker using the text-based workbench. You can also perform these tasks using the TIBCO Object Service Broker UI, which provides a graphical environment for TIBCO Object Service Broker development. For information about using the TIBCO Object Service Broker UI, refer to the TIBCO Object Service Broker UI online help.
Available Methods
A number of methods are available for you to manipulate the data in your tables from within TIBCO Object Service Broker. You can use:
Choosing a Tool
The method that you choose determines the tool that you use. Your choice depends on when and how you want to manipulate the data. Use the following table to determine the best option for your requirements:
Browsing Data with the Table Browser
You can use the Table Browser to browse data defined in the MetaStor. When you are using the Table Browser, you do not lock access to data defined in tables. The following section describe what you can and cannot do when browsing a table with the Table Browser.
What You Can Do With the Table Browser
When browsing data with the Table Browser, you can:
Refer to Available Table Types for a description of each table type.
Browse tables that have a maximum of eight fields in the composite primary key, although TIBCO Object Service Broker allows a maximum of 16 fields in a composite primary key.
Browse tables with fields of syntax UN (UTF-16 Big Endian Unicode character strings). Unicode strings are shown as sequences of groups of four hexadecimal digits, each group representing a Unicode character.
Browse tables with fields of syntax RD (strings of raw binary data bytes). Raw data strings are shown as sequences of groups of two hexadecimal digits, each group representing a raw data byte.
Use the primary command SHOW (or its corresponding function key PF19) to display and/or re-display fields excluded from the screen because of a long primary key or because the EXCLUDE command was issued.
What You Cannot Do With the Table Browser
When browsing data with the Table Browser, you cannot:
Manipulating Data with the Table Editor
You can use the Table Editor to edit an entire table in the database. It combines the features of a full-screen editor and a line editor. The Table Editor locks the table instance if the table is parameterized that you are using so that other users cannot access it to make editing changes. Therefore, if only minor changes are required to the table, use the Single Occurrence Editor.
Note the following considerations when manipulating data with the Table Editor.
What You Can Do With the Table Editor
When manipulating data with the Table Editor, you can:
Edit tables that have a maximum of eight fields in the composite primary key, although TIBCO Object Service Broker allows a maximum of 16 fields in a composite primary key.
Use the primary command SHOW (or its corresponding function key PF19) to display and/or re-display fields excluded from the screen because of a long primary key or because the EXCLUDE command was issued.
What You Cannot Do With the Table Editor
When manipulating data with the Table Editor, you cannot:
Manipulating Data with the Single Occurrence Editor
You can use the Single Occurrence Editor to update or display a single occurrence in a table.
Note the following considerations when manipulating data with the Single Occurrence Editor.
What You Can Do With the Single Occurrence Editor
When manipulating data with the Single Occurrence Editor, you can:
Make changes to tables while using the Table Browser or Table Editor. The Single Occurrence Editor locks a single occurrence rather than the whole table or table instance if the table is parameterized.
What You Cannot Do With the Single Occurrence Editor
You cannot use the Single Occurrence Editor on IMP tables.

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