Display or Print Tables
If you have OnLine Query, and you are defined as a user of CA OLQ, you can use the Query function of ASF. The Query function enables you to display a data table in table format and to print a table as a report.
Select QUERY
Select QUERY ([PF13]) from the Activity Selection screen. The Column Select screen of CA OLQ is displayed, listing the columns of the JOB table.
Note: The column names listed by CA OLQ are in the stored format used internally by ASF. In the stored format, spaces and special characters are replaced with hyphens (-).
CA-OLQ *** COLUMN SELECT *** -> PAGE 1 OF 1 124000 Select columns, specify selection criteria and press ENTER key COLUMNS CURRENTLY SELECTED: 5 SELECTION CRITERIA _ JOB X 03 JOB-NUMBER * X 03 DEPARTMENT-0002 X 03 TITLE X 03 SALARY X 03 CURRENT-STATUS-FILLED-OR-OPEN
Select Columns and Rows
This screen enables you to select the columns of the table you want to display, and to specify criteria for selecting rows of the table. Depending on the default in effect at your site, either all the columns in the table are selected (marked by X) or none of the columns are selected (marked by D). For this example, select all the columns in the table.
Press [Enter]. The Retrieval Completed screen is displayed. This screen lists the activities you can perform on the table. By default, the Display Report function is selected.
CA-OLQ *** Retrieval Completed *** -> 130000 Select activity and press the ENTER key Number of whole rows. . . . . . . . 4 Total number of records read. . . . 4 Total number of records selected. . 4 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
Press [Enter]. The Display Report screen is displayed. This screen shows the columns and rows of the JOB table.
CA-OLQ *** Display Report *** -> Page 1 Line 1 104009 DISPLAY RIGHT to see more report columns 125004 Press ENTER for DISPLAY/FORMAT ACTIVITY selections JOB REPORT mm/dd/yy JOB NUMBER DEPARTMENT TITLE SALARY ---------- -------------------- ------------------------------ --------- B359 BILLING BILLING CLERK 10000.00 C417 CLAIMS CLAIMS ADJUSTER 17000.00 O198 OFFICE SERVICES MAIL CLERK 7000.00 END OF REPORT CA-OLQ *** Display Report *** -> Page 1 Line 1 125004 Press ENTER for DISPLAY/FORMAT ACTIVITY selections JOB REPORT mm/dd/yy TITLE SALARY CURRENT STATUS (FILLED OR OPEN) ------------------------------ --------- ------------------------------- ASSISTANT UNDERWRITER 13500.00 FILLED BILLING CLERK 10000.00 OPEN CLAIMS ADJUSTER 17000.00 OPEN MAIL CLERK 7000.00 OPEN END OF REPORT - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 10=LEFT 11=RIGHT
To display the entire table, press the appropriate PF-keys to page horizontally, or type the commands DISPLAY RIGHT and DISPLAY LEFT on the command line.
Returning from CA OLQ
When you have displayed the entire table, press [Clear].
The Menu screen appears, listing all the activities you can perform with CA OLQ. For more information about CA OLQ activities, see the CA OLQ Online Query for CA IDMS User Guide
Press [Clear] from the CA OLQ Menu screen to return to the Activity Selection screen of ASF.
|
Copyright © 2014 CA.
All rights reserved.
|
|