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


Chapter 3 Managing IDMS/DB Data Definitions : Task A  Invoke the Table Definer

Task A  Invoke the Table Definer
The Table Definer can be invoked from the workbench using either the DT define table option or the primary command field. You can access an existing definition or define a new IDM table.
Accessing Existing Tables
You can display the definition of an existing IDM table from the workbench in one of three ways:
DT EMPLOYEE_DENTAL<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.
Defining a New Table
To define a new table, complete the following steps:
1.
Valid entries are a character string of up to 16 characters beginning with a letter (A - Z) or a special character ($ or #), and 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.
This displays a TDS definition template.
2.
The initial IDM table definition screen appears, similar to the one shown below:

 
COMMAND==> TABLE DEFINITION
Table: EMPLOYEE_DENTAL Type: IDM Unit: USR40
IDM Table Specification
Defining SUBSCHEMA: Run Time SUBSCHEMA:
IDMS Ready Mode: SR Optimize Update: N
Server ID: DEFAULT DBName:
-----------------------------------------------------------------------------
Show? Lvl Record Name Get Forall Set Name Opt
--------------- - --- --------------- --- --- ---------------- --
PFKEYS: 1=HELP 2=DOC 3=SAVE 5=ELEMENTS 6=RECORDS 12=CANCEL 9=SAVE MIN 22=DEL

 
Definition Screen Segments
The initial IDM table definition screen is divided into the following four segments:
Header segment
Table Specification segment
Record segment
Displays the records that make up the chosen access path for your table definition. These records are for display purposes only; they can be changed only from the CA‑IDMS Record and the Set Connections screens. Refer to Task D  Select CA‑IDMS Records and Task E  Specify Record Connections for more information.
PF Keys segment
Modifying the Header Segment
The header segment of the initial IDM table definitions screen contains the following fields:
Displays the table name specified when you invoked the Table Definer. You can type in a new name to save the definition of the current table under a new name.
A character string of 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 (_).
Displays the user unit associated with the table. The unit marks the table as belonging to a particular application or to a logical unit such as utilities, accounting, or network control. The default unit for your user ID is specified in your TIBCO Object Service Broker user profile.
A character string up to a maximum length of eight characters. These can be provided by your system administrator, for example, ACC.
PF Keys and Primary Commands
You can use the following PF keys or their corresponding primary commands (or their abbreviations) from the initial IDM table definition screen:
PF Key
Displays the Documentation screen, where you can document the table definition. Refer to Appendix A, Documenting IDM Tables for more information.
Displays the Elements screen, where you can choose elements for each record in the access path.
Displays the Records screen, where you can choose records to be part of the access path.
Deletes the definition of the IDM table. When you press Enter, you are prompted to confirm the deletion.
See Also
TIBCO Object Service Broker Getting Started for more information on the Object Manager
TIBCO Object Service Broker Shareable Tools for more information on copying TIBCO Object Service Broker objects

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