DB2 graphic QMF Version 8

Creating a report

You can create a report from a selection list or from the End User Facility Report Maintenance panel.

Creating directly

To create a report entry from the End User Facility Report Maintenance panel, you must enter the following fields:

Action
Enter C (for create).
Report Owner
Enter the owner for this report. The owner entered must be a valid primary or secondary SQLID or must be of the form T=tranid, where tranid is a valid CICS transaction identifier. In the latter case, the report will be associated with that transaction, rather than with a particular owner.
Report Name
Enter the name for this report. No spaces are allowed in the report name. The combination of report owner and name must be unique.

Creating from a selection list

To create a report entry from the Report Selection List panel, you must enter the following field:

Action
Enter C (for create). This action will be treated as a Create Like... The attributes of the profile entry selected with the action of C will be used as default attribute values on the Create Report Registration panel.

Create Report Registration panel

If you are creating a report from the End User Facility Report Maintenance panel, this panel lists default attribute values when it is first displayed. If you are creating a report from the Report Selection List panel, this panel lists the attribute values from the report that was selected.

Table 26. Create Report Registration
DB2P / DB2PLOCATION -- Create Report Registration -------------------- 8.1.0
Command ===>
 
Owner................... ===>
Name.................... ===>
Description ===>
Shared?................. ===>
Program Name............ ===>
Load Library............ ===>
Plan Name............... ===>
Environment............. ===>
Program Type............ ===>
COBOL Dialect........... ===>
Attachment Facility..... ===>
Uses Variables?......... ===>
Host Variable File LRECL ===>
Input Data LRECL........ ===>
Output Data LRECL....... ===>
Report LRECL............ ===>
Number of Report Files.. ===>
Query Name.............. ===>
Form Name............... ===>
Procedure Name.......... ===> 

If you press Enter, the attribute values will be validated. If any errors are detected during input validation, the panel will be redisplayed with an error message. Otherwise, if the Uses Variables? field is set to YES, you will proceed to the Edit Variables panel. If the Uses Variables? field is set to NO, the report will be created (an entry will be inserted into Q.REPORTS), and you will proceed to the next panel or return to the previous panel if no more actions have been requested.

If you press PF3, the attribute values will be ignored and the report will not be created. You will proceed to the next panel or return to the previous panel if no more actions have been requested.

If you type ABORT and press Enter, the attribute values will be ignored, the report will not be created, and you will return to the previous panel.

The fields on the panel are:

Owner
Enter the owner for this report. The value entered must be a valid primary or secondary SQLID or must be of the form T=tranid, where tranid is a valid CICS transaction identifier. For a tranid, this report will be associated with that transaction rather than with a particular owner. This field is disabled if the report is being updated.
Name
Enter the name for this report. No spaces are allowed in the name. The combination of owner and name must be unique. This field is disabled if the report is being updated.
Description
Enter a report description (55 characters maximum).
Shared?
Enter YES if this report should be visible to all users or NO if it should be visible only to users with authority to SET CURRENT SQLID to the report owner.
Program Name
If this report runs a program, enter the program name. Leave this field blank if this report runs a QMF query or procedure.
Load Library
If this report runs a program, you can enter the name of the load library where the program is located. Leave this field blank if this report runs a QMF query or procedure.
Plan Name
If this report runs a program, you can enter the name of the plan to run with the program. Leave this field blank if this report runs a QMF query or procedure.
Environment
Enter BATCH, TSO, or CICS, depending on the environment in which this report should run. Set this field to TSO if this report runs a QMF query or procedure.
Program Type
Enter P (print), D (display), N (no report), L (data layer), or R (proc), depending on the type of program. Set this field to P or Dif this report runs a QMF query or procedure.
COBOL Dialect
If this report runs a program, enter 0S/VS COBOL, VS COBOL II, COBOL FOR MVS, or COBOL FOR OS/390, depending on the language in which the program is written. Enter QMF if this report runs a QMF query or procedure.
Attachment Facility
If this report runs a program, enter TSO, CAF, RRSAF, or CICS, depending on the attachment facility used by the program. Leave this field blank if this report runs a QMF query or procedure.
Uses Variables?
If this report runs a program that uses host variables, enter YES. If this report runs a QMF query or procedure that uses variables, and you want the End User Facility to prompt for variable values, enter YES. Otherwise, enter NO. If you enter YES, a subsequent panel will be displayed on which you can specify the variable names and data types.
Host Variable File LRECL
If this report runs a batch program that uses host variables, enter the LRECL to use for the HOSTVARS or PROCVARS DD at runtime. Otherwise, this field is set to 0 and is ignored.
Input Data LRECL
If this report reads data from an input file, enter the LRECL of that file; otherwise, set this field to -1.
Output Data LRECL
If this report writes data to an input file, enter the LRECL of that file; otherwise, set this field to -1.
Report LRECL
Enter the LRECL of the report written by this program; otherwise, set this field to -1 if it is not known or not applicable.
Number of Report Files
Enter the number of REPORTnn DDs written by this report, or enter -1 if it is not known or not applicable.
Query Name
If this report runs a program that was generated from a query or runs a QMF query, enter the name of the query. Otherwise, leave this field blank.
Form Name
If this report runs a program that was generated from a query and form or runs a QMF query and form, enter the name of the form. Otherwise, leave this field blank.
Procedure Name
If this report runs a program that was generated from a procedure or runs a QMF procedure, enter the name of the procedure. Otherwise, leave this field blank.

Edit Variables panel

When you create a new report, this panel does not list variable definitions. When you edit an existing report, this panel will initially list the current variable definitions for that report. Enter variable definitions for the report on this panel.

Table 27. Edit Variables
DB2P / DB2PLOCATION -- Edit Variables For QMFUSER.REPORT -------------- 8.1.0
Command ===>                                                Scroll ===> PAGE
 
Valid Actions Are...
D  Delete
I  Insert
R  Repeat
-----------------------------------------------------------------------------
       Variable Name                    Type
       -------------------------------  ---------------
 
****************************** Bottom of data ******************************
 
 
 
 
 
 

If you press Enter, line commands and variable definitions will be validated and processed. If any errors are detected during input validation, the panel will be redisplayed with an error message. Otherwise, if any line commands are processed, the panel will be redisplayed. If there are no line commands, the variable definitions will be created (entries will be inserted into Q.REPORT_VARIABLES), and you proceed to the next panel or you return to the previous panel if no more actions have been requested.

If you press PF3, the variable definitions will be ignored and the report will not be created. You will proceed to the next panel or return to the previous panel if no more actions have been requested.

If you press PF7 or PF8, the panel will scroll backward or forward.

If you type ABORT and press Enter, the variable definitions will be ignored, the report will not be created, and you will return to the previous panel.

The fields on the panel are:

Line commands
Enter any of the following the characters as line commands:
Variable Name
Enter the name of the variable. Omit the colon (:) at the beginning of host variable names and omit the ampersand (&) at the beginning of QMF variable names.
Type
Enter the data type of the variable. Valid data types are SMALLINT, INTEGER, DECIMAL(p,s), DECIMAL(p), DECIMAL, FLOAT, CHAR(n), VARCHAR(n), DATE, TIME, and TIMESTAMP.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004