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:
- D to delete a line
- I to insert a line
- R to repeat a line
- 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.
