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


Chapter 3 Managing IDMS/DB Data Definitions : Task E  Specify Record Connections

Task E  Specify Record Connections
Set Connections Screen
You use the first display of the Set Connections screen, shown below, to choose how to access the first record in the access path. The sample screen below displays four possible access choices via:
The EMP-NAME-NDX Index
The DEPT-EMPLOYEE set
The OFFICE-EMPLOYEE set

 
COMMAND==> TABLE DEFINITION
Table: EMPLOYEE_DENTAL Type: IDM Unit: USR40
-----------------------------------------------------------------------------
Record(s) connected to >
-----------------------------------------------------------------------------
Record Name Set Name Options
---------------- ---------------- -- -------
_ SR7 EMP-NAME-NDX OA INDEX
_ DEPARTMENT DEPT-EMPLOYEE OA OWNER
_ OFFICE OFFICE-EMPLOYEE OA OWNER
_ ** AREA SWEEP ** AREA
Y <- Select all fields from this record?
-----------------------------------------------------------------------------
Show? Lvl Record Name Get Forall Set Name Opt
--------------- - --- --------------- --- --- ---------------- --
1 EMPLOYEE OC OFA
PFKEYS: 1=HELP ENTER=SELECT 5=ELEMENTS 4=CANCEL 18=-RECORD 9=CONNECT 12=RETURN
Select INDEX, SET or AREA you want to navigate

 
When accessing the first record via a set (second and third options), ensure you established the proper record currencies before accessing this table.
Procedure
Type an S beside the access method you want to use to access the first record in the access path, for example, DEPARTMENT, and press Enter. The Set Name field (access method) for the first record in the access path appears. The subsequent screens show the next set of records that can be added to your access path. You have the following two options:
After adding the required number of records, press PF5 to move to the Elements screen. Refer to Task F  Define CA‑IDMS Elements for more information on selecting elements.
Field Values
The Set Connection screen is divided into two sections. The top section contains the following fields:
The name of the CA‑IDMS record attached to the current record.
The name of an index for a record or the name of the set that connects two records. If the first record in the access path has more than one index, all index names are listed.
The Gateway uses this field to determine whether explicit CONNECT or DISCONNECT commands are required. Possible set membership options are:
Owner or Member Field
Select all fields from this record?
The default Y automatically includes all elements from the record in the table definition. If set to N, you can selectively include elements from the record.
The bottom section of the screen displays records that you chose previously as part of the access path. The last record in the list is the current record. This section contains the following fields:
Contains one of the following entries if there is a possibility of empty or duplicate records. If you type a Y beside this entry, the field means the following:
Show if Set Empty: Include the record even if the set is empty. The fields associated with the empty set have NULL values.
Show if No Owner: Include the record even if there is no owner. The fields associated with the owner have NULL values.
Name of the CA‑IDMS record. The last name in the list is the current record.
The CA‑IDMS directive code used to retrieve the CA‑IDMS record when a TIBCO Object Service Broker GET is issued.
The CA‑IDMS directive code that is used to retrieve the CA‑IDMS record when a TIBCO Object Service Broker FORALL is issued. The codes are:
PF Keys
You can use the following keys from the IDMS/DB Set Connections screen:
Removes the record where the cursor is placed from the access path, moving you up one level in the access path.

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