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


Chapter 4 Defining the Accesses to Adabas : Task B: Invoke the Table Definer

Task B: Invoke the Table Definer
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.
Accessing Existing Tables
Display the definition of an existing ADA table from the workbench in one of three ways:
DT EMPLOYEE<Enter>
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:
SELECT TYPE=’ADA’
To select a table, type S in the line command field and press Enter.
Defining a New Table
To define a new table, complete the following steps:
1.
This displays a TDS definition template.
2.
A Table Definition screen similar to the following appears.
 

 
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

 
Following are the TIBCO Object Service Broker ADA Table Definition Screen Segments
 
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.
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.
Using Table Definer PF Keys
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
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.

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