![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Task A: Define a DAT Table
An instance of the server does not have to be running to define a DAT table, as the information that you extract in Extraction of Table Information is stored in a TIBCO Object Service Broker TDS table.Invoke the Table Definer from the workbench using the DT define table option or the primary command field. You can modify an existing definition or define a new DAT table. Use the DATACOM tool to specify the initial values for your definition.
• Type the name of an existing table beside the DT define table option and press Enter to display its definition.DT PERSONNEL<Enter>.
• Move the cursor to the DT define table option and press Enter to display the Object Manager screen, which contains a list of existing tables.Scroll through this list to see which table you require. To select a table, type S beside the name and press Enter.TIBCO Object Service Broker Getting Started for more information on the Object Manager.
1. Type the name of a new DAT table beside the DT define table option or in the primary command field and press Enter.
If the definition is generated using the DATACOM tool, this field displays the table name supplied by default; otherwise, the field is blank. The default is the name of the CA Datacom table converted to a valid TIBCO Object Service Broker name. Modify the default name as required.A valid entry is a character string up to 16 characters, beginning with a letter (A-Z) or a special character ($ or #), and continuing with more letters, special characters, digits (0-9), or underscore characters (_).A table name starting with an @ symbol denotes a table supplied by TIBCO Object Service Broker. The user unit associated with the table. To modify this field, use the Core screen. Refer to Task C: Add Control Information for more information. The ID for the server or group of servers associated with the table. This ID must match the SERVERID parameter specified in the server JCL. Refer to Specifying the Startup Parameters for more information. Optional. The URT name. Ensure that a load module with this name and default entry point DBNTRY is available to load for the server at runtime. Optional. The Data Dictionary name of the CA Datacom table to be accessed. A valid entry is any valid CA Datacom table name. Press PF1 to access a list of the CA Datacom tables loaded into TIBCO Object Service Broker. The fully qualified name of the file that contains the respective COBOL copybook if you created this definition with the Eclipse UI-based definer. You cannot modify this field. Optional. The data-cleansing actions, if any, the server is to carry out. This field is optional. Optional. The CA Datacom identification number for the CA Datacom database that is being used. Required. The CA Datacom name that uniquely identifies the table within the CA Datacom database being used. A value of Y if duplicate master keys are allowed for the CA Datacom table; a value of N if only a single master key is allowed for the CA Datacom table. The CA Datacom element list used by the server at runtime when this table is accessed. You cannot modify this field.The fields DBID, Internal Name, and Duplicate Key are filled in with default information after you have entered the value of the Dictionary Name field. Refer to Using the DATACOM Tool for more information.You can, however, manually enter or modify the DBID, Internal Name, and Duplicate Key fields. You cannot enter or modify the value of the Element List field.Execute the DATACOM tool from the EX execute rule option on the workbench to display the CA Datacom table management facility screen illustrated below. Use this facility to generate a definition for your DAT table. See the screen in Extraction of Table Information.To display a list of CA Datacom tables available for mapping as TIBCO Object Service Broker DAT-table definitions (that is, those CA Datacom tables whose metadata has previously been extracted) and the existing DAT definitions, follow these steps:
1. Position your cursor next to the “Manage TIBCO OSB DAT-type table definitions” option and press Enter.
2. Find the table you need, type G in the line command field, and press Enter.
4. Scroll through the list to the name of the new table, type S in the line command field, and press Enter.Use the following PF keys and their corresponding primary commands (or their abbreviations) from the Table Definition screen.
PF Key Primary Command Displays Help for the Table Definer. Also displays a list of available CA Datacom table names if you position your cursor on the DATACOM Name field. You can select one table from this list. Displays the documentation screen, where you can document the table definition. Refer to , Task D: Document the DAT Table for more information. Validates the definition information specified in the Table Definition, Core, and Extensions screens. If valid, it returns you to the workbench. Displays the Extensions screen, where you select the Datacom fields that you want defined as fields in the DAT table.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |