In this example, you:
Start on the Saved Reports screen. To get there, type save in the command line.
Choose Select. Select the SALARIES report.
CA OLQ Release nn.n *** Saved Reports *** -> Page 1 of 1 120000 Select report function, report name, and press the ENTER key DOC1 Saved reports for user: DOC1 Function: c Select _ Create _ Replace _ Delete _ Delete all Enter report name: Retention period: 1 Report Name Time Date Retention c SALARIES 13:46:23:21 6/15/99 1 Days 1=HELP 3=QUIT 4=MESSAGE 6=MENU PA2=REFRESH
Specify picture on the command line. CA OLQ displays the SALARIES report.
CA OLQ Release nn.n *** Display Report *** -> picture Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE/EMPOSITION REPORT mm/dd/yy SOCIAL SECURITY SALARY NAME NUMBER GRADE SALARY ─────────────── ─────────── ────── ────────────────────── FITZHUGH 11-234-5678 11 13000.00 TERNER 04-567-2222 11 13000.00 JOHNSON 01-134-7878 11 13500.00 ─────────── AVE FOR 11: 13166.66 NICEMAN 03-345-6110 12 14000.00 GARDNER 02-233-4444 12 14000.00 KRAAMER 02-378-6666 12 14000.00 KING 06-784-5516 12 14500.00 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
Add a leading dollar sign and commas to your computation by selecting the $ and , options next to the listing of the computation syntax.
CA OLQ Release nn.n *** Report Format - Picture *** -> Page 1 of 1 137000 Specify pictures and press the ENTER key Disp Select Options or Alter Seq $ , 0 Picture EMPLOYEE X EMP-LAST-NAME-0415 1 X(15) X SS-NUMBER-0415 2 _ _ _ 99-999-9999 EMPOSITION X SALARY-GRADE-0420 3 _ _ _ 99 X SALARY-AMOUNT-0420 4 _ _ _ -ZZZZZZ9.99 COMPUTE FIELDS: X SALARY-AMOUNT-0420-AVE-3=AVE(SALARY- x x _ -ZZZZZZ9.99 AMOUNT-0420) GROUP BY SALARY-GRADE-0420 LEVEL 1 Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 10=EDIT 11=GROUP BY
Your summary computation is listed with a leading dollar sign and separating commas.
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 SOCIAL SECURITY SALARY NAME NUMBER GRADE SALARY ─────────────── ─────────── ────── ──────────────────────── FITZHUGH 11-234-5678 11 13000.00 TERNER 04-567-2222 11 13000.00 JOHNSON 01-134-7878 11 13500.00 ───────────── AVE FOR 11: $13,166.66 NICEMAN 03-345-6110 12 14000.00 GARDNER 02-233-4444 12 14000.00 KRAAMER 02-378-6666 12 14000.00 KING 06-784-5516 12 14500.00 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
Select Replace. Select the SALARIES saved report.
CA OLQ Release nn.n *** Saved Reports *** -> Page 1 of 1 120000 Select report function, report name, and press the ENTER key DOC1 Saved reports for user: DOC1 Function: _ Select _ Create x Replace _ Delete _ Delete all Enter report name: Retention period: 1 Report Name Time Date Retention x SALARIES 13:46:23:21 6/15/99 1 Days 1=HELP 3=QUIT 4=MESSAGE 6=MENU PA2=REFRESH
CA OLQ returns you to the Menu screen and issues a message indicating that your report has been saved.
CA Software CA OLQ Release nn.n *** Menu *** -> Page 1 of 3 107001 The SALARIES report has been saved successfully 122000 Select an option and press the ENTER key Select Command/ Show Pfkey Option Description Screen Name Help ---> Data Source for Report <--- _ Choose tables TABle _ _ Choose subschema SUBschema _ ---> Retrieval Activity <--- _ Choose records from selected subschema RECord _ _ Choose columns for report COLumn _ _ Retrieve data to build report RETrieve _ _ Alter database access strategy LINkage _ ---> Processing Mode <--- _ Execute or create a predefined routine QFIle _ _ View existing or save current report SAVe _ _ Submit batch report request BATch _ 1=HELP 2=GLOBAL HELP 3=QUIT 4=MESSAGE 8=FWD
|
Copyright © 2013 CA.
All rights reserved.
|
|