******************************* Bottom of data ********************************
F1=HELP F2=SPLIT F3=END F4=QPRINT F5= F6= F7=UP F8=DOWN F9=SWAP F10= F11= F12=RETRIEVE
Figure 5–87, Select Output Destination Panel
5.5.17.2 Output Destination Panel
The Select Output Destination panel displays a list of destinations. Those destinations are defined by User ID and vary from user to user, so you may not be able to send a report to all the
destinations described below.
• RMDS—Report Management and Distribution System (RMDS) is an IBM product that provides an intermediate area to view reports before they are routed to a destination. RMDS identifies each report by its report identifier. A report is routed to RMDS by specifying the RMDS print destination and placing the report identifier in the FORM field on the output menu from CICS or QMF. From RMDS, a user can send a copy of a report to any of the other valid report destinations. Except for printer output, any report routed out of RMDS is placed in a dataset for further processing. RMDS is accessible from a TSO or VTAM session.
• PC Download—Output to be downloading to a user’s PC is stored in separate datasets on the NSLDS mainframe. Those data sets are differentiated from other distribution datasets by a naming standard which includes the userid in the data set name. When users download from Personal Communications/3270 or Crosstalk for Windows, they specify the data set name as the source for the download. These files begin with NSLPC.userid.
• Diskette—Each report or extract to be distributed on diskette is stored in a separate data set on the mainframe. A naming standard indicates which datasets are to be copied onto diskette. At regular intervals, a diskette distribution process is executed in batch to collect the data sets and transfer them to a dedicated PC. The Output Log table is updated to reflect that the output has been sent to the PC. This diskette distribution process uses the userid, which is imbedded in the dataset name, to read the user name and mailing address from the User Profile table. The name and address are placed at the beginning of the data set before it is transferred to the PC.
• Magnetic Tape—The processing for magnetic tape distribution is very similar to the processing for diskettes. A naming standard which requires that the userid of the requester be included in the database name identifies which data sets are to be sent to tape. For each data set, a distribution process reads the “User Profile” table and sends the mailing information to a printer for mailing labels. After the data set is copied to tape and the tape is mailed, a CICS transaction is used to update the “Output Log” table.
The REPORT ID is a four-character identifier based on organization; refer to Section 5.10 for a listing of valid identifiers. QMF prompts you to identify the report when it reaches the given destination. This is required, so you must enter a response.
• Type a valid identifier at the “Report ID” prompt.
• Select the desired destination by typing S beside the RMDS option. • Press ENTER.
QMF displays the word “selected” to the right of the option denoting which destination was selected. The selection can be changed by typing S beside a different destination and pressing
ENTER. RMDS sends the report to the NSLDS Data Center for printing.
After selecting the destination:
• Type QPRINT at the “Command” prompt. • Press ENTER.
• Press END (F3) from the Destination panel, to terminate the output process. • Press HELP (F1) to receive online HELP.
• Press the END key to exit the Output Destination panel.
5.5.17.3 QPRINT Command
Another way to produce output from the Report panel is to use the QPRINT command.
• QPRINT—Displays the Output Destination panel just as pressing the REPORT key does.
• QPRINT dest rptid—Bypasses the Select Output Destination panel and sends the output directly to the desired destination. In this example, replace DEST with the desired
destination of the output. RPTID should be replaced with the REPORT ID.
To produce output from the Report panel, follow these steps:
• Type QPRINT RMDS XXXX at the “Command” prompt on the Report panel. • Press ENTER.
Always use the command QPRINT rather than PRINT. The PRINT command does not allow you to select a destination and report ID, but QPRINT does.
5.6 Advanced SQL Queries
5.6.1 Summarizing Data
There are times when you do not need to view all detail records on your report but only summary data. You can create summary reports in QMF using one of two options:
1. The QMF Form panels 2. The SQL Query panel
You may want to select the SQL query method if you are summarizing a large amount of data. For example, if you have written a query that selects 20,000 rows and you want to summarize these rows into a smaller report, it would be better to select just the summarized rows rather than all 20,000 rows and then summarize the data in the form.
5.6.2 Using Forms
To create a summary report from the QMF Form panels, use Form.Main’s USAGE column.
• Press the QUERY key.
• Type RESET QUERY at the “Command” prompt. • Press ENTER.
Enter the following query at the top of the screen:
SELECT CURR_LEN_CODE, SCH_CODE, AMT