Selection Criteria - Dataset Specification screen


The Selection Criteria - Dataset Specification screen is the first screen displayed when you invoke Option 6. This screen is not displayed when you edit temporary selection criteria from within the Extract function.

Selection Criteria - Dataset Specification screen

File-AID for IMS  ---  Selection Criteria - Dataset Specification  ------------
 COMMAND ===>                                                                   
 ENV: TEST - IMS ENVIRONMENT                        
                                                                               
 + Selection criteria Dataset . . ‘CW.FISAMP.SELCRIT’                           
                       Member . .          (Blank or pattern for member list)   
 -------------------------------------------------------------------------------
 Enter DBD dataset name to which selection criteria will be applied:            
           + DBDLIB Dataset 1 . . 'CW.FISAMP.DBDLIB'                       
                    Dataset 2 . .                                               
                       Member . . PORDR    (New criteria - Specify member or    
                                                           blank for list      
                                            Existing criteria - Member ignored)
 -------------------------------------------------------------------------------
  Use application relatnships . . Y        (Y = Yes; N = No)                    
  + Appl relationship Dataset . . 'CW.FISAMP.APPLREL'                      
 -------------------------------------------------------------------------------
           Use COBOL layouts . .. Y        (Y - Required for formatted selection
                                            N - Segment/unformatted selection)  
 + Segment/Layout XREF dataset  . 'CW.FISAMP.XREFC'                        
                       Member . .          (Blank or pattern for member list)   
                                                                             
     + COBOL  layout Dataset 1. . 'CW.FISAMP.COBOLLIB'                   
                     Dataset 2. .

Important

The presence of a highlighted plus (+) or minus (-) sign indicates data set concatenations. For more information, see Data-set-concatenation-support.

Selection Criteria Dataset

Enter the selection criteria dataset you want to edit. The data set must conform to the characteristics of a valid selection criteria dataset as described in Selection Criteria Dataset Concatenation.

Member

Enter the name of the member in the selection criteria dataset. If the field is left blank or a pattern is specified, a member list is displayed. Select a member from the list.

DBDLIB Dataset 1 and Dataset 2

Enter one or two DBD load library data set names. If you enter one DBD load library name, you can enter it on either of the data set name lines. If you enter two DBD load library names and their block sizes are different, you must enter the library with the larger block size on the first data set name line.

Member

Enter the DBD member that describes the database that you want to create selection criteria for. If two DBD libraries are entered, File-AID for IMS searches the first before the second to locate the DBD member.

When you create a new selection criteria dataset or member, it will contain the DBD member name you specify in this section of the screen. When you edit the selection criteria at a later time, the DBD Member field on the screen is ignored and the one contained in the selection criteria is used.

Use Application Relationships

Indicate whether you want to define the selection criteria with an application relationship.

Appl Relationship Dataset

You must enter the application relationship dataset name when using an application relationship. Either the DBD member name specified on the screen for a new selection criteria file or the DBD name in an existing selection criteria file is used as the member name for the application relationship dataset.

Use Layouts

Indicate whether segment layouts are to be used to define the selection criteria. For more information, see Segment/Layout XREF Dataset Concatenation.

If you intend to create or edit formatted field selection criteria, you must enter Y in this field.

If your installation has both the COBOL and PL/I language support options of File-AID for IMS installed, ensure that your current language mode is compatible with the segment layout and segment/layout XREF dataset information you specify. Your current language mode is indicated by the word COBOL or PL/I preceding the Use Layouts and the Layout Dataset fields. To change language mode, enter the COBOL or PLI primary command on the COMMAND line.

File-AID for IMS/ISPF maintains separate concatenations of COBOL and PL/I layouts and cross-reference datasets. These concatenations automatically toggle between the COBOL and PL/I sets when you enter the COBOL or PLI command. Layouts and cross-reference datasets that you have entered for use with COBOL are kept separate from those you have entered for PL/I

Segment/Layout XREF Dataset and Member

When you create a new selection criteria dataset or member that contains formatted field selection criteria, it is assigned a single record type status or multi-record type status based on the information contained in the segment/layout XREF member. The segment/layout XREF member, created and maintained using Option 7, is described in detail on here.

When you edit the selection criteria at a later time, the segment/layout XREF information must result in the same record type (single or multiple) as originally specified when the selection criteria were created. If the segment/layout XREF information you enter results in a type different from the original, the message RECORD TYPE CONFLICT is displayed, and you cannot edit the selection criteria.

When you create a new selection criteria dataset or member that does not contain formatted field selection criteria, it is not assigned a record type status. You can later edit the selection criteria regardless of the Use Layouts indicator you specify at the time.

If your installation has both COBOL and PL/I language support options of File-AID for IMS installed, when you create a new selection criteria dataset or member that contains formatted field selection criteria, it is assigned a language status of COBOL or PL/I based on your current language mode. When you edit the selection criteria at a later time, you must be in the same language mode that the selection criteria were originally created. If your language mode is different than the selection criteria’s language status, the message SLCTN CRIT/LANG CONFLICT is displayed, and you cannot edit the selection criteria.

A language status is not assigned to selection criteria datasets that do not contain formatted field selection criteria. You can later edit the selection criteria regardless of your language mode at the time.

Layout Dataset 1 and Dataset 2

Enter the data set names where the layouts specified by the segment/layout XREF reside.

If you enter one segment layout data set name, you can enter it on either line. If you enter two segment layout data set names, they can appear in any order. Each library can be any of the valid segment layout library organization types. For more information, see Segment Layout Dataset Concatenation.

Terminating the Screen

Do one of the following to terminate the Selection Criteria - Dataset Specification screen:

  • Press ENTER to proceed to the next screen. Depending on the information entered, you can receive up to three member list screens:
    • One for the selection criteria dataset.
    • One for the DBD load library data set.
    • One for the segment/layout XREF dataset.
  • Enter the END, RETURN, or jump command to leave the selection criteria option.

Error Summary

If you are editing selection criteria that you previously created in Option 6, after you press ENTER on the Selection Criteria - Dataset Specification screen, File-AID for IMS reads the selection criteria dataset and matches it with the segment/layout XREF information. If errors are found in the matching process, the Selection Criteria Error Summary screen is displayed, as shown in the following figure.

Selection Criteria Error Summary Screen

File-AID for IMS  --  Selection Criteria Error Summary  ---- APPL REL MISMATCH
COMMAND ===>

MISMATCH BETWEEN DBD AND SELECTION CRITERIA MEMBER
MISMATCH BETWEEN APPLICATION RELATIONSHIPS AND SELECTION CRITERIA MEMBER  

Datasets used when last save was made:
            DBDLIB dataset 1: ’CW.FISAMP.DBDLIB1’
                   Dataset 2: ’CW.FISAMP.DBDLIB2’
                      Member: PORDR  

   Appl relationship dataset: ’CW.FISAMP.APPLREL’
 Segment/Layout XREF dataset: ’CW.FISAMP.XREF’
                      Member:  

      COBOL layout dataset 1: ’CW.FISAMP.COBOLIB1’
                   Dataset 2: ’CW.FISAMP.COBOLIB2’  

Press ENTER to ignore mismatches and continue editing this member
Enter END to return to the previous panel without saving this member

Error Messages

Errors can occur in the matching process for any of the following reasons:


    • Incorrect segment layout or segment/layout XREF information was entered on the Selection Criteria - Dataset Specification screen.
    • The segment layouts used to create the formatted field selection criteria has changed.
    • The segment/layout XREF used to create the formatted field selection criteria has changed.
    • The application relationships applied to the selection criteria have changed.
    • The selection criteria have been modified outside Option 6 (for example, in ISPF/PDF Option 2).

Following is the text and description of each message:

Selection Criteria - Validation Errors

MISMATCH BETWEEN DBD AND SELECTION CRITERIA MEMBER
This error can occur if the DBD definitions were changed since the file was last saved. File-AID for IMS deletes the DBDs no longer defined when you edit and save the selection criteria. Following are the most likely causes:

  • Logical DBDs were added and/or deleted in the DBD since the selection criteria were last edited.
  • The selection criteria were modified outside Option 6.

MISMATCH BETWEEN APPLICATION RELATIONSHIPS AND SELECTION CRITERIA MEMBER
This error can occur when the selection criteria contain target DBDs that are no longer defined in the application relationship or the DBD definition has changed. File-AID for IMS deletes the DBDs no longer defined when you edit and save the selection criteria. Following are the most likely causes:

  • Target DBDs were added and/or deleted in the application relationship since the selection criteria were last edited.
  • Logical DBDs were added and/or deleted in the DBD since the selection criteria were last edited.
  • Application relationships were not applied when the selection criteria were previously defined with application relationships.
  • The selection criteria were modified outside Option 6.

MISMATCH BETWEEN SEG/LAYOUT XREF AND SELECTION CRITERIA MEMBER

This error can occur for both single and multi-record type formatted field selection criteria. For a single record type, the error occurs when File-AID for IMS attempts to look up the segment/layout XREF and retrieve the segment layout. For multi-record type, the error occurs when File-AID for IMS attempts to look up the record type values in the segment/layout XREF and retrieve the segment layout. Following are the most likely causes:

  • The wrong segment/layout XREF dataset was specified.
  • The correct segment/layout XREF was specified, but it has changed since the selection criteria were last edited.
  • The selection criteria were modified outside Option 6.

MISMATCH BETWEEN COBOL/PL/I LAYOUT AND SELECTION CRITERIA MEMBER

This error can occur when a segment layout changes. For example, the starting position in the layout was changed or the data type was changed for fields where formatted selection criteria were entered. File-AID for IMS discards the selection criteria for the mismatched field. Following are the most likely causes:

  • The COBOL or PL/I layout has changed since the selection criteria were last saved.
  • The selection criteria have been modified outside Option 6.

INVALID OR MISSING RECORD-SKIPPED TO NEXT VALID CRITERIA

This error occurs when File-AID for IMS encounters an invalid record or determines that a record is missing from the selection criteria dataset. File-AID for IMS attempts to skip to the next valid set of field selection criteria. This error can occur when the selection criteria were modified outside Option 6.

Datasets Used When Last Save Was Made

Displays information about the DBDLIB, application relationship, segment/layout XREF, and layout data sets that were used the last time the file was saved.

Terminating the Screen

Do one of the following to terminate the Selection Criteria Error Summary screen:

  • Enter the END command to terminate the editing of the selection criteria and return to the Selection Criteria - Dataset Specification screen.
  • Press ENTER to proceed with editing the selection criteria despite the errors. The Selection Criteria - Menu screen is displayed.

Selection Criteria Menu

If there are no errors in the selection criteria or if there are errors and you press ENTER on the Selection Criteria Error Summary screen, the Selection Criteria - Menu screen is displayed as shown in the following figure. This is the first screen displayed when you create temporary selection criteria from within the Extract function.

Selection Criteria - Menu Screen

File-AID for IMS  ----------  Selection Criteria - Menu  ----------------------
OPTION  ===>

                                                 Data base access:             

Select option by entering the option number or by entering the option name  

   1  Specify SEGMENT criteria
   2  Specify FIELD criteria
   3  Specify data base RELATIONSHIP criteria  
-------------------------------------------------------------------------------  
Use secondary indexing ===> N
             Index DBD ===>

Enter Selection Criteria Member Description:  

SHORT DESCR ===>                                 (Used on member list)
 Extended   ===>
Description ===>

Specify prompting level desired ===> N         (N = New user; E = Experienced)  

The commands SEG, FLD, and REL can be used from any Selection Criteria panel
to invoke Options 1, 2, or 3 respectively

Data Base Access

Indicates whether primary database root segments are accessed directly or sequentially during the extract process. For more information, see Direct Access Processing on database access.

Select Option

Enter one of the following options or commands:

1 or SEG

The Segment Criteria - Segment List screen (here) is displayed.

2 or FLD

The Field Criteria Set List screen (here) is displayed.

3 or REL

The Relationship Specification screen (here) is displayed.

Use secondary indexing

Indicate whether you want to access the primary DBD through a secondary index.

Index DBD

Specify the secondary index DBD name when using secondary indexing. If left blank File-AID for IMS displays the the Secondary Index Database List screen. For more information, see Secondary Indexing.

Important

The 2 fields, Use secondary indexing and Index DBD, do not show on the panel if the database has no secondary indexes.

Short Descr

Enter a short 30-byte description for the selection criteria member. This description is displayed on the Member List screen for the selection criteria dataset. This field is valid only for existing selection criteria and is not displayed when editing temporary selection criteria.

Extended Description

Enter two lines (62 bytes each) of extended description for both temporary and existing selection criteria.

Specify Prompting Level Desired

Specify whether you are a new or experienced user of File-AID for IMS. If you specify N, the informational screens associated with the Segment Criteria and Field Criteria options are displayed. Specify E to skip the informational screens. Examples of the informational screens can be found in Segment Criteria and Field Criteria.

Common Primary Commands

Following is a list of selection criteria primary commands. Commands that are specific to Segment, Field, or Relationship criteria are described under those sections. Scroll commands (UP, DOWN, LOCATE) apply only to scrollable lists and are described in Scrolling. See Primary Commands for an explanation of these and other File-AID for IMS/ISPF primary commands.

CANCEL

Terminates the edit session without performing a save.

END

Terminates the current operation and returns control to the next higher-level screen without performing a save.

FIELD

Accesses the Field Criteria Set List screen from any screen within the selection criteria option.

RELATIONSHIP

Accesses the Relationship Specification screen from any screen within the selection criteria option.

RETURN

Returns to the Primary Option Menu or the option specified. A save is issued if changes were made to the file.

SAVE

Updates the selection criteria file to reflect changes made. For sequential datasets, the entire data set is rewritten (see also SAVE).

SAVEAS (SAVAS)

Allows you to save the selection criteria to a different file or member (see also SAVEAS ).

SEGMENT

Accesses the Segment Criteria - Segment List screen from any screen within the selection criteria option.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*