Online Session › A Sample Selection Criteria Specification Session › Step 2. Specify the Source and Target Subschemas › Specify Database Extract Specification Screen

Specify Database Extract Specification Screen

CA─IDMS/DBX Rnn.nn ───  Specify Database Extract Specification ─ hh:mm mm/dd/yy
COMMAND ===>                                                            USVMSPC

Enter Spec Name and, if a new spec, Subschema and DB Names, press ENTER

Specification
   Name ===> dept-teacher                       (blank for Specification list)

Source Subschema  ====> testsub1   DMCL ===> CVDMCL
   Dictionary Name ===>
   Dictionary Node ===>
   Database Name   ===>            (or Segment)
   Database Node   ===>

Target Subschema  ====> loadsub1   DMCL ===> CVDMCL
   Dictionary Name ===>
   Dictionary Node ===>
   Database Name   ===>            (or Segment)
   Database Node   ===>

Compare Subschemas ===> Y  (Y/N)

Because the specification shown in the Name field is a new specification, you must also enter the names of the source and target subschemas. CA IDMS Extractor allows the same subschema to be named as the source subschema and the target subschema.

For the sample session

The data structure diagram for the STUDENT-TEACHER database shown in Data Structure Diagram for the Sample Session. For this sample session, the target database is to consist of DEPT records that own TEACHER records, selected from an existing source database. The other selection criteria follow:

• Define a path that has the DEPT record as an Entry Record
• Extract the first DEPT, and every fifth DEPT record after the first
• Limit the number of extracted DEPT records to 40
• Limit the extracted records to a subset of its from/to page range
• Extract every second TEACHER record in the DEPT-TEACHER set
• Place no limit on the number of TEACHER records.

The name of the specification is DEPT-TEACHER and both source and target databases reside in the primary dictionary for the CV under which you are running.

1. Type DEPT-TEACHER in the Specification Name field.
2. Use the TAB key to move to the Source Subschema field and type TESTSUB1.
3. Use the TAB key to move to the Source Subschema Database Name field and type STUDTCHR.
4. Use the TAB key to move to the Target Subschema field and type LOADSUB1.
5. Use the TAB key to move to the Target Subschema Database Name field and type STUDTCHR.
6. Press the ENTER key.

The Database Entry Point Selection Menu screen is displayed.