Extended Screens › Extended Selection Definition Screen—XSEL

Extended Selection Definition Screen—XSEL

Description

The Extended Selection Definition screen allows you to specify, as part of a table definition, the data to be included in the table. Selection definition is most often used when defining views; you can select the data from the derivation source(s) that you want included in the view.

Access

You can access the Extended Selection Definition screen in one of the following ways:

• Select the Extended Selection Definition function from the Column Definition screen or from the Extended Table Definition screen; you can select the function by pressing [PF3].
• Enter XSEL in the screen name field of any screen.

Sample Screen

                                            CA
  XSEL   CA - Automatic System Facility       *Extended Selection Definition*
  DC560603 ENTER SELECTION CRITERIA
  Table Name: EMPLOYEE1
               _ PF1 - Help      _ PF2 - Message Screen          Page:  1  of  1

   ID           Column Name                      Selection Criteria
  0001 EMP-ID-0415
  0002 EMP-FIRST-NAME-0415
  0003 EMP-LAST-NAME-0415
  0004 EMP-STREET-0415
  0005 EMP-CITY-0415
  0006 EMP-STATE-0415
  0007 EMP-ZIP-0415                     MATCHES '02###'
  0008 EMP-PHONE-0415                   MATCHES '617#######'
  0009 EMP-STATUS-0415                  '01'
  0010 EMP-START-YEAR-0415              GE '1980'




                          Additional Selection Criteria
 $7 OR $8

Fields

The fields on the Extended Selection Definition screen are the same as those on the Data Selection screen. Refer to "Data Selection Screen" in the chapter "Basic Screens"for field descriptions.