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


Chapter 3 Managing IDMS/DB Data Definitions : Task D  Select CA‑IDMS Records

Task D  Select CA‑IDMS Records
After completing the necessary fields in the IDM table specification segment, you must select CA‑IDMS records for your definition. Press PF6 to display the CA‑IDMS RECORDS screen, shown below. The sample screen below lists all records defined for the selected subschema EMPSS01.

 
COMMAND==> TABLE DEFINITION
Table: EMPLOYEE_DENTAL Type: IDM Unit: USR40
-----------------------------------------------------------------------------
Select ONE starting record from SUBSCHEMA > EMPSS01
------------------------------------------------------------------------------
N <- Select all fields from this record?
_ COVERAGE (VIA) _ DENTAL-CLAIM (VIA) _ DEPARTMENT (CALC)
_ EMPLOYEE (CALC) _ EMPOSITION (VIA) _ EXPERTISE (VIA)
_ HOSPITAL-CLAIM (VIA) _ HRNTRXDB (CALC) _ INSURANCE-PLAN (CALC)
_ JOB (CALC) _ NON-HOSP-CLAIM (VIA) _ OFFICE (CALC)
_ DENTAL (CALC) _ STRUCTURE (VIA)
S-Select starting record
PFKEYS: 1=HELP ENTER=SELECT 12=RETURN 4=CANCEL

 
Type an S beside the record that you want as the starting record in your access path and press Enter. The Set Connections screen for that record appears. For example, if you choose the EMPLOYEE record as the starting record, a screen similar to the one shown in Task E  Specify Record Connections appears.
You can also type a Y in the Select all fields from this record? field. This automatically includes all elements from the record in the table definition. The default is N.

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