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


Chapter 4 Managing DB2 Data Definitions : Task B  Invoke the Table Definer

Task B  Invoke the Table Definer
Invocation Functions
Invoke the Table Definer from the workbench using the DT define table option or the primary command field. There are two functions you can perform:
These functions are described in the following sections.
Accessing Existing Tables
You can display the definition of an existing DB2 table from the workbench in one of three ways:
DT EMPLOYEE<Enter>
Move the cursor to the DT define table option and press Enter. This displays 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.
 
See Also
The TIBCO Object Service Broker Getting Started manual for information on the Object Manager.
Defining a New Table
To define a new table, complete the following steps:
1.
Type the name of a new TIBCO Object Service Broker DB2 table beside the DT define table option or in the primary command field and press Enter.
A TDS definition template appears.
2.
A screen similar to the one shown below appears.

 
COMMAND==> TABLE DEFINITION
Table: EMPLOYEE_DB2 Type: DB2 Unit: VZO10
Dictionary : X (X/I) ServerID: DEFAULT ServerType: DB2 Orders: Y ImplUpd: N
Subtype : N (N/P/R)
Creator :
Table :
DB2 Location:
 
Location Parm Typ Syn Len Dec Default ' Event Rule Typ Acc
---------------- --- --- --- -- ---------------- ' ---------------- - -
_ ' _
' _
 
| ------------- DB2 Column -------------------------|------------ OSB Field ----
Name Datatype Len Scale |Num Name Typ Syn
------------------------------ -------- ----- -Def|--- ---------------- - --
 
 
 
 
(S=Select P=Parameter K=Key)
PFKEYS: 4=DB2 TBLS 3=END 12=CANCEL 2=DOC 22=DELETE 5=RS_INFO 9=RS_REFRESH

 
Screen Elements:
DB2 Column and Metadata Field
Displays the columns of the DB2 table or the parameters of a procedure on which your TIBCO Object Service Broker DB2 table is based and your chosen TIBCO Object Service Broker fields. For details, see Task D  Select DB2 Columns.
PF Keys
The table below describes the commands (or abbreviations) that correspond to the PF keys:
PF Key
Primary Command
Depending on the value of the Subtype field (N or P/R), lists the existing DB2 creators/tables or schemas/procedures, respectively, upon which you can base your TIBCO Object Service Broker DB2 table.

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