Copyright © Cloud Software Group, Inc. All Rights Reserved

Task B: Invoke the Table Definer

Invoke the Table Definer from the workbench using the DT define table option. You can modify an existing definition or define a new IMS table.

Accessing Existing Tables

You can display the definition of an existing IMS table from the workbench in one of three ways:

•	Type the name of an existing table beside the DT define table option and press Enter to display its definition.

•	Type the name of an existing table in the primary command field, for example:

DT CUST_ORDERS<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.	Type the name of a new IMS table beside the DT define table option or in the primary command field and press Enter.

A TDS definition template appears.

2.	Change the Type field at the top of the screen from TDS to IMS and press Enter.

A Table Definition screen similar to the one shown below appears.

---

 

COMMAND==> TABLE DEFINITION

Table: CUST_ORDERS Type: IMS Unit: USR40

DB Name:

Server ID: DEFAULT Server Type: IMS Optimize Update:

PSBname: OSTRXDRP Browse PSBname: OSTRXDRQ

Location Parm Typ Syn Len Dec Default Src Sourcename

---------------- --- --- --- -- ---------------- - ----------------

_ LOCATION I C 16 0

Level Segment Name Fields Chosen Order From Segment

-- -------- ---------------- --- --------

_ 0

Event Rule Type Access Parms Chosen Order From Segment

---------------- - - ---------------- --- --------

_

_

_

PFKEYS: 3=SAVE 12=CANCEL 22=DELETE 13=PRINT 6=CHILD SEGMENTS 2=DOC 4=DB NAMES

---

 

IMS Table Definition Screen Segments

The IMS table definition screen contains the following segments:

Header segment	Specifies the name, type, and unit specifications for the table. Refer to Task C: Specify Header Information for more information.
IMS Database segment	Specifies the IMS database on which you want to base the table definition. Refer to Task D: Select an IMS Database for more information.
Location Parameter segment	Specifies a location parameter for the IMS table. Refer to Task E: Define a Location Parameter for more information.
IMS segment	Displays the IMS segments on which you want to base your IMS table. Refer to Task F: Select IMS Segments for more information.
Fields segment	Displays the IMS fields you chose from the selected IMS segments. Refer to Task G: Select IMS Fields for more information.
Event Rule segment	Specifies event rules for the IMS table. Refer to Task H: Define Event Rule Information for more information.
Parameter segment	Displays data parameters for the IMS table. Refer to Task G: Select IMS Fields for more information.
PF Keys segment	Displays the PF keys available from this screen. Refer to the table below for more information.

PF Keys and Primary Commands

Use the following PF keys or primary commands (or their abbreviations) from the IMS Table Definition screen:

PF Key	Primary Command	Description
	COPY	Copies the definition of an existing IMS table into the current definition.
PF1	-	Displays corresponding help for the current field or screen.
PF2	DOC	Displays the documentation screen, where you can document the table definition. Refer to Appendix A, Documenting IMS Tables for more information.
PF3	SAVE	Saves the existing definition and returns you to the workbench.
PF4	DB NAMES	Lists existing IMS databases upon which you can base your IMS table.
PF6	-	Displays the child segments of the current segment.
PF12	CANCEL	Cancels any changes to the definition and returns you to the workbench.
PF13	PRINT	Prints the definition of the table. You remain in the Table Definer.
PF22	DELETE	Deletes the definition of the IMS table. You are prompted to confirm the deletion.

See Also

TIBCO Object Service Broker Getting Started for more information on the Object Manager.

Copyright © Cloud Software Group, Inc. All Rights Reserved