DB2 graphic QMF Version 8

Generating programs with the full dialog panel

Program generation is initiated from the Generate Programs (Full Dialog) panel or the Generate Programs (Short Dialog) panel. Most of the discussion in this chapter on generating programs refers to the Full Dialog option. Using the Short Dialog option to generate programs is discussed later in this chapter, as is generating programs using batch JCL.

Select option 1 from the Program Generator Menu to display the Generate Programs (Full Dialog) panel. This panel can also be reached by issuing the following TSO command:

CALL 'QMFHPO.SRAALOAD(RAAMAIN)' 'CO 1'

Table 5. Generate Programs (Full Dialog) Panel
DB2P / DB2PLOCATION -- Generate Programs (Full Dialog) --------------- 8.1.0
Command ===>
Use % and _ as wildcard characters to produce a list of objects
Press ENTER to proceed to next panel.
Type CAN or CANCEL or press PF3 to end.
 
Generate programs from one of the following:
1. Query Name.... ===>
 
2. Query Name.... ===>
   Form Name..... ===>
 
3. Procedure Name ===>
 
 
 

If you press Enter, all input fields will be validated. If any errors are detected during input validation, the panel will be redisplayed with an error message. Otherwise, the program generation process will begin.

If you press PF3, all input fields will be ignored and you will return to the Program Generator Menu.

Before you can generate a program, you must identify the input source: a query, a query and form combination, or a linear procedure. If you choose a query or a query and form, a Report List with one report will be produced. If you choose a query with no form, the same default form settings as QMF are assumed, and a form name of *DEFAULT will be used. If you choose a procedure, the procedure will be parsed, and a Report List will be produced consisting of all reports specified in the procedure.

You do not need to specify a form to generate a stored procedure program or a data layer program. You enter the name of a query or the name of a procedure that refers to queries from which to generate stored procedure programs or data layer programs.

The fields on the panel are:

Query Name
Enter the name of a query from which to generate a program. If the name is unqualified, then the current SQLID will be used as the query owner. You can enter the name QUERY to specify the current QMF query object. You can use % and _ as wildcard characters in the name to produce a list of queries from which to select.
Form Name
Enter the name of a form from which to generate a program (along with a query). If the name is unqualified, then the current SQLID will be used as the form owner. You can enter the name FORM to specify the current QMF form object. You can use % and _ as wildcard characters in the name to produce a list of forms. Leave this field blank to generate a stored procedure program or a data layer program.
Procedure Name
Enter the name of a linear procedure from which to generate programs. If the name is unqualified, then the current SQLID will be used as the procedure owner. You can enter the name PROC to specify the current QMF PROC object. You can use % and _ as wildcard characters in the name to produce a list of procedures from which to select.


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