Use Data Selection Screen
The Activity Selection screen is displayed. Select the Select Data function ([PF5]) from the activity selection menu.
The Data Selection (DSEL) screen is displayed. This screen enables you to specify selection criteria for displaying rows of the view. ASF will display only the rows that match the criteria you specify.
The column names of the view are listed below the Column Name field heading. Each column has been assigned an identification number, which is listed below the ID field heading to the left of the Column Name field. You can use the ID numbers in place of column names when specifying selection criteria.
Required Salary &le. Salary
In this example, you want to select the rows from the JOBS AND APPLICANTS view in which the salary required by the applicant is less than or equal to the salary being offered for the position.
The cursor is positioned at the first field under the Selection Criteria field heading. Press [Return] to move the cursor to the SALARY REQUIREMENT column name. Type the selection criterion le #4 in this field. Note that the ID number 4, preceded by a pound sign (#), enables you to reference the SALARY column name in your selection criterion.
CA DSEL CA - Automatic System Facility ** Data Selection ** DC560603 ENTER SELECTION CRITERIA Table Name: JOBS AND APPLICANTS _ PF1 - Help _ PF2 - Message Screen Page: 1 of 1 ID Column Name Selection Criteria 0001 JOB NUMBER 0002 DEPARTMENT 0003 TITLE 0004 SALARY 0005 CURRENT STATUS (FILLED OR OPEN) 0006 NAME 0007 PHONE NUMBER 0008 POSITION APPLIED FOR 0009 SALARY REQUIREMENT le #4 0010 EVALUATION: STRONG,WEAK,MEDIUM 0011 SALARY DIFFERENTIAL Additional Selection Criteria
You have just specified that you want to display the rows of the JOBS AND APPLICANTS view in which the entry in the SALARY REQUIREMENT column is less than or equal to the entry in the SALARY column.
ASF Uses your Selection
Press [Enter]. ASF saves the selection criteria you have entered, and the message SELECTION MODIFIED, HIT ENTER TO PROCEED TO DATA SELECTION is displayed. Press [Enter] again.
The Data Display screen is displayed automatically. It displays the columns of the JOBS AND APPLICANTS table and the first row that matches the selection criteria you specified. Notice that the value in the SALARY REQUIREMENT column is less than or equal to the value in the SALARY column and that the SALARY DIFFERENTIAL column contains a value that is less than or equal to zero.
Note: If you make an error when entering the selection criteria, you remain on the Data Selection screen. The field names to which the erroneous selection criteria apply are highlighted. The message display line instructs you to access the Message screen, which lists all the error conditions.
CA PF1 = ADD; PF2 = CHANGE; PF3 = DELETE; ENTER = NEXT; CLEAR = EXIT JOBS AND APPLICANTS JOB NUMBER O198 DEPARTMENT OFFICE SERVICES TITLE MAIL CLERK SALARY 7000.00 NAME TIMOTHY MURRAY SALARY REQUIREMENT 6000.00 EVALUATION: STRONG,WEAK,MEDIUM STRONG SALARY DIFFERENTIAL -1000.00
Press [Enter] to display the next selected row. Continue to press [Enter] until all the rows you selected have been displayed.
Press [Enter] again to redisplay the first selected row.
|
Copyright © 2014 CA.
All rights reserved.
|
|