When you save a report CA OLQ takes the set of commands you used to build your current report and saves them in the data dictionary. In this step, you build a current report.
This report uses the EMPLOYEE and EMPOSITION records from the sample employee database. These records reside in the EMPSS01 subschema.
Start on the Signon Database View screen. To get there, type subschema (or sub) in the command line of any screen.
Select the EMPSS01 subschema.
CA OLQ Release nn.n *** Signon Database View *** -> Page 3 OF 4 121000 Select a subschema and press the ENTER key Dictionary name . : TSTDICT Dictionary node name . : Database name . . : Database node name . . : Specify Subschema : of Schema . . . : Version : -or- Select subschema: Description: s EMPSS01 OF EMPSCHM VER 100 DEPARTMENT AND EMPLOYEE INFORMATION _ FINANC01 OF EMPSCHM VER 100 4Q87 _ SALES01 OF EMPSCHM VER 100 SALES QUOTAS 1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 8=FWD PA2=REFRESH
Select the EMPLOYEE and EMPOSITION records.
CA OLQ Release nn.n *** Record Select *** -> Page 1 of 1 123000 Select records and press the ENTER key Records currently selected: 0 Enter records : -and/or- Select records : _ COVERAGE _ DENTAL-CLAIM _ DEPARTMENT s EMPLOYEE s EMPOSITION _ EXPERTISE _ HOSPITAL-CLAIM _ INSURANCE-PLAN _ JOB _ NON-HOSP-CLAIM _ OFFICE _ SKILL _ STRUCTURE 1=HELP 3=QUIT 4=MESSAGE 6=MENU PA2=REFRESH
Select EMP-LAST-NAME-0415, SS-NUMBER-0415, SALARY-GRADE-0420, and SALARY-AMOUNT-0420. Press [PF8] to scroll through the screen.
CA OLQ Release nn.n *** Column Select *** -> Page 1 of 3 124000 Select columns, specify selection criteria and press the ENTER key Columns Currently Selected: 0 Selection Criteria Distinct N Y/N _ EMPLOYEE _ 02 EMP-ID-0415 * _ 02 EMP-NAME-0415 _ 03 EMP-FIRST-NAME-0415 * s 03 EMP-LAST-NAME-0415 * _ 02 EMP-ADDRESS-0415 _ 03 EMP-STREET-0415 _ 03 EMP-CITY-0415 _ 03 EMP-STATE-0415 _ 03 EMP-ZIP-0415 _ 04 EMP-ZIP-FIRST-FIVE-0415 _ 04 EMP-ZIP-LAST-FOUR-0415 _ 02 EMP-PHONE-0415 _ 02 STATUS-0415 Additional selection criteria: Proceed to Selection Criteria Screen? N Y/N 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD PA2=REFRESH
Select Yes to continue data retrieval.
CA OLQ Release nn.n *** Retrieval Interrupted *** -> 131000 Select YES or NO and press the ENTER key Retrieval interrupted due to excessive data base accesses. Number of whole rows. . . . . . . . 54 Total number of records read. . . . 100 Total number of records selected. . 99 Number of data errors . . . . . . . 0 Continue execution x Yes X No Current interrupt interval is 100 data base accesses. 1=HELP 3=QUIT 4=MESSAGE
CA OLQ Release nn.n *** Retrieval Completed *** -> 130000 Select activity and press the ENTER key Number of whole rows. . . . . . . . 68 Total displayable cols . 20 Total number of records read. . . . 125 Formatted line length. . 372 Total number of records selected. . 124 Number of data errors . . . . . . . 0 Select Command/ Option ---> Display/Format Activity <--- Screen Name X Display report DISplay _ Save report SAVe _ Choose the sort sequence of report SORt _ Change column headers HEAder _ Change page header and footer PAGe HEAder _ Change display format of data ($,commas) PICture _ Format columns (Alignment, sparse) EDIt _ Specify summary computations (Totals) GROup BY _ Send the report to a printer PRInt 1=HELP 3=QUIT 4=MESSAGE 6=MENU
This is how your report looks before you add any formatting features.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE/EMPOSITION REPORT mm/dd/yy EMP-LAST-NAME-0415 SS-NUMBER-0415 SALARY-GRADE-0420 SALARY-AMOUNT-0420 ────────────────── ────────────── ───────────────── ────────────────── LINGER 092345812 33 38500.00 TERNER 045672222 11 13000.00 BROWN 019556712 44 42500.00 CHARLES 019556712 43 38000.00 PENMAN 014593186 33 39000.00 DUNCAN 010673343 72 85000.00 EVERETT 010673343 71 75000.00 LITERATA 023567831 43 37500.00 WILCO 111000023 72 80000.00 HEAROWITZ 031896154 42 33000.00 TYRO 019893456 21 20000.00 KAHALLY 029661234 21 20000.00 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
|
Copyright © 2013 CA.
All rights reserved.
|
|