![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
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.A number of methods are available for you to manipulate the data in your tables from within TIBCO Object Service Broker. You can use: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:
Update a table that has event rules defined. Execute the shareable tool STE or use rules. CT copy table workbench option or shareable tools. CL clear table workbench option or shareable tools.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.
• Browse TDS, SUB, CLC, EES, SES, IMS, PRM, VSM, DAT, DB2, ADA, SLK, and IDM table types.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.
• Browse tables that have more than eight fields in a composite primary key. You must use rules to access the tables.
A dot (.) appears when the field length exceeds the maximum display size. To view the field, use the Single Occurrence 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.
• 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.
• Roll back editing changes made to VSM type tables. Changes are committed as soon as they are made.
• Edit tables that have more than eight fields in a composite primary key. You must use rules to access the tables.
A dot (.) appears when the field length exceeds the maximum display size. To view the field, use the Single Occurrence Editor.Note the following considerations when manipulating data with the Single Occurrence Editor.
• 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.
• Display and edit fields that are too large for the display table in either the Table Browser or the Table Editor.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |