![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Invoke the Table Definer from the workbench using the DT define table option or the primary command field. You can access an existing definition or define a new TIBCO Object Service Broker ADA table.
• Use the DT define table option with no table name. This displays the Object Manager screen, which lists existing tables in your TIBCO Object Service Broker database.Scroll through this list to see which table you require. Use the SELECT command to filter the list to show only tables of type ADA:To select a table, type S in the line command field and press Enter.
1. Type the name of a new ADA table beside the DT define table option or in the primary command field.
COMMAND==> TABLE DEFINITION
Table: ADAEXAMPLE Type: ADA Unit: USR40
Serverid: DBID: FILE No.: Server->EE Block: 0
ISN Assigner: SYSTEM (System/User) Use GF ID:N Name of countfield:
Repeat Type: (PE/MU) MU/Special Fld in Grp: Y Occurs/Read: 5
Location Parm Typ Syn Len Dec Default ' Event Rule Typ Acc
---------------- --- --- --- -- ---------------- ' ---------------- - -
LOCATION I C 16 0 ' _
' _
| -------- External Field -------- | ---------------- Metadata Field -------
|Ext Name Syn Len Dec Upd Fmt Des| Name Typ Syn Len Dec Ord Def
-------- - ----- -- - - - --------------- - --- ----- -- - ---_
_
_
_
_
(K=Key D=Delete I=Insert R=Replicate)
PFKEYS: 3=SAVE 12=CANCEL 22=DELETE 13=PRINT 2=DOC 5=COLUMNS
New table definition
Where you specify the Adabas table on which to base your new ADA table and address access control information. Refer to Task C: Specify Header Information for more information. Where you specify an optional location parameter for the new ADA table. Refer to Specifying Optional Location Parameter Information for more information. Where you specify one or more optional event rules for the new ADA table. Refer to Specifying Optional Event Rule Information for more information. External field and Metadata field Displays the columns of the Adabas table on which your new ADA table is based and the TIBCO Object Service Broker fields that you chose. Refer to Task E: Select Extracted Fields for more information. Displays the PF keys available from this screen. Refer to Using Table Definer PF Keys for more information.The following table describes the PF keys that are available from the Table Definer screen and their corresponding primary commands or abbreviations:
PF Key Primary Command Copies the definition of an existing ADA table into the current definition. Displays the screen for documenting the table definition. Refer to Task G: Document ADA Tables for more information. Saves changes to the existing definition and returns you to the workbench. Displays the external fields list from which you can select Adabas fields.To obtain information from the extracted Adabas file definition, the fields DBID and FILE No must be entered for PF5 to become active. When these fields are supplied, use PF5 to list the fields that were in the Adabas definition when the extract was performed. All relevant fields are set when you return from Adabas field selection screen. Cancels the changes to the definition and returns you to the workbench. Deletes the definition of the ADA table. You are prompted to confirm the deletion.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |