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


Chapter 2 The Table Definer : What is the Table Definer?

What is the Table Definer?
TIBCO Object Service Broker UI
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.
Overview
You use the Table Definer to specify and modify the definitions of your data tables. This tool, as it is described here, is accessible from the developer’s workbench via the Define Table option. It is also available from the administrator’s workbench. Chapter 3, Defining TDS, EES, SES, and TEM Tables and Chapter 4, Defining a View of a Source Table describe the Table Definer as it is used to define the following table types:
For descriptions of how to define other table types, refer to Chapter 1, Overview of Data Structures.
Accessing the Table Definer
You can access the Table Definer from the workbench by doing one of the following:
Type a new or existing table name to the right of the DT define table option and press Enter. This displays the initial Table Definer screen.
Position your cursor to the right of the DT define table option and press Enter. This displays the Object Manager screen for the Table Definer. Select an object from this screen to invoke the Table Definer screen.
Execute the tool DEFINE_TABLE (tbl_name) where tbl_name is the name of a table.
You can also access the Table Definer from within the OS object set workbench option. To access the Table Definer, from within the first screen, position your cursor on the name of a table object and press PF9.
Layout of the Screen
The initial screen that appears when you enter the Table Definer is used to define TDS, TEM, EES and SES tables. This screen is divided into four segments:
The layout of the initial screen changes if you are editing the definition of a table of type SUB, CLC, or PRM. For additional information refer to Chapter 4, Defining a View of a Source Table.
Example
The following example shows a definition screen for the @EMPLOYEES table.

 
COMMAND==> TABLE DEFINITION
Table: @EMPLOYEES Type: TDS Unit: DOCEXMPL IDgen: N
Parameter Name Typ Syn Len Dec Class ’ Event Rule Typ Acc
---------------- - - --- -- - ’ ---------------- - -
_ REGION I C 16 0 D ’ _ DELETEMPNO T D
_ LOCATION I C 16 0 L ’ _ VALIDEMPNO V I
Field Name Typ Syn Len Dec Key Ord Rqd Default Reference
---------------- - - ---- -- - - - ---------------- ----------------
_ EMPNO I P 3 0 P
_ LNAME S C 22 0 S Y
_ POSITION S C 14 0
_ MGR# I P 3 0 MANAGER
_ DEPTNO I B 2 0
_ SALARY Q P 4 2 0.00
_ ADDRESS S V 38 0
_ CITY S C 20 0
_ STATE_PROV S C 4 0
_ ZP_CODE S C 7 0
_ HIREDATE D B 4 0
 _
PFKEYS: 3=END 12=CANCEL 22=DELETE 13=PRINT 14=FIELDS 21=DATA 2=DOC

 
See Also
TIBCO Object Service Broker Application Administion for information on the administrator’s workbench.

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