Installing sample queries and procedures required for the installation verification procedures

Install the sample QMF queries and procedures only on TSO.

Prerequisites
Starting QMF

Some of these objects are required by the installation verification procedures for both TSO and CICS®. After the objects are installed under TSO, they are then available for use under CICS. Other objects are provided for users to refer to while learning how to use QMF.

The sample queries and procedures have changed in QMF Version 13.1, so you must delete prior versions and install the new versions.

The following table describes the sample queries.
Table 1. QMF Version 13.1 sample queries
Name of data set from which query is imported Name under which QMF saves the object after importing it Description
DSQ0EQ1 Q.SAMPLE_SELECT1 Simple SELECT query
DSQ0EQ2 Q.SAMPLE_SELECT2 SELECT query with IN keyword and ORDER BY clause
DSQ0EQ3 Q.SAMPLE_SELECT3 SELECT query with BETWEEN and NULL keywords and AND and OR operators
DSQ0EQ4 Q.SAMPLE_SELECT4 SELECT query that uses LIKE keyword
DSQ0EQ5 Q.SAMPLE_SELECT5 SELECT query that does a join of two tables
DSQ0EQ6 Q.SAMPLE_SELECT6 SELECT query that uses MAX, MIN, and AVG functions
DSQ0EQ7 Q.SAMPLE_SELECT7 SELECT query with GROUP BY and HAVING clauses; COUNT function
DSQ0EQ8 Q.SAMPLE_SELECT8 SELECT query that uses a UNION operator
DSQ0EQ9 Q.SAMPLE_SELECT9 SELECT query that uses a subquery
DSQ0EQ10 Q.SAMPLE_SELECT10 SELECT query with correlated subselection
DSQ0EQ11 Q.SAMPLE_SELECT11 SELECT query with EXISTS keyword
DSQ0EQ12 Q.SAMPLE_INSERT1 INSERT query to add a single row to a table
DSQ0EQ13 Q.SAMPLE_INSERT2 INSERT query to copy one or more rows into a table
DSQ0EQ14 Q.SAMPLE_UPDATE UPDATE query
DSQ0EQ15 Q.SAMPLE_DELETE DELETE query
DSQ1EQ16 Q.SAMPLE_DATABASE Query that uses the CREATE DATABASE statement
DSQ1EQ17 Q.SAMPLE_TABLESPACE Query that creates a table space
DSQ1EQ18 Q.SAMPLE_CREATETABLE Query that creates a table
DSQ0EQ19 Q.SAMPLE_CREATEINDEX CREATE INDEX query
DSQ0EQ20 Q.SAMPLE_CREATEVIEW Query that creates a view
DSQ0EQ21 Q.SAMPLE_GRANT Query that grants update privileges
DSQ0EQ22 Q.SAMPLE_REVOKE Query that revokes update privileges
DSQ0EQ23 Q.SAMPLE_DROP Query that drops a table from a database
DSQ0EQ25 Q.SAMPLE_COMMENT Query that saves a comment with a table
The following table describes the sample procedures.
Table 2. QMF Version 13.1 sample procedures
Name of data set from which procedure is imported Name under which QMF saves the object after importing it Description
DSQ0BIQ1 Q.IVP_QUERY_COUNT

Provides a row count for a given input table.
DSQ0BIQ2 Q.IVP_QUERY_DELETE Deletes QMF_IVP_QUERY from the catalog
DSQ1EIVP Q.DSQ1EIVP IVP procedure to verify interactive operation under TSO
DSQ1EBAT Q.DSQ1EBAT Batch IVP procedure to verify batch operation under TSO
DSQ1EIVC Q.DSQ1EIVC CICS IVP procedure
DSQAED1S Q.DSQAED1S Installs the document editing interface function
DSQABL01
DSQAEL0D
DSQABL0D
Q.DSQABL01
Q.DSQAEL0D
Q.DSQABL0D

Installs procedures for the LAYOUT application, which supports the LAYOUT command synonym
Complete the following steps to delete sample queries and procedures from the prior QMF version and install the QMF Version 13.1 objects:
  1. Begin a QMF session.
  2. Make sure that you are connected to the Db2® for z/OS® subsystem in which you just installed QMF.
  3. Delete prior versions of the sample queries and procedures. If you installed QMF Version 13.1 in a system where no previous QMF release existed, skip this step.
    1. Enter the following command to display the procedure that deletes the queries and procedures: 
      IMPORT PROC FROM QMF1310.SDSQSAPE(DSQ1ESQD)'
      In this command and throughout the DSQ1ESQD procedure, QMF1310 is the prefix for the QMF Version 13.1 data sets. If you used a different prefix, change QMF1310 in the command and wherever it occurs in the procedure to the site-specific prefix that you have chosen. If you are using QMF on TSO, you can use the EDIT PROC command, followed by an ISPF command such as CHANGE, to change the prefix information. For example, the following ISPF command changes the prefix from QMF1310 to the prefix DB2TOOLS: 
      CHANGE 'QMF1310' 'DB2TOOLS' ALL
    2. Issue the RUN PROC command to run the procedure.
  4. Install the Version 13.1 sample queries and procedures.

    Enter the following command to display the procedure that installs the Version 13.1 queries and procedures:

    IMPORT PROC FROM 'QMF1310.SDSQSAPE(DSQ1ESQI)'
    In this command and throughout the DSQ1ESQI procedure, QMF1310 is the prefix for the QMF Version 13.1 data sets. If you used a different prefix, change QMF1310 in the command and wherever it occurs in the procedure to the site-specific prefix that you have chosen. If you are using QMF on TSO, you can use the EDIT PROC command, followed by an ISPF command such as CHANGE, to change the prefix information. For example, the following ISPF command changes the prefix from QMF1310 to QMF1310: 
    CHANGE 'QMF1310' 'QMF1310' ALL
  5. Issue the RUN PROC command to run the procedure.

    You should receive a message that indicates that the objects were installed correctly. If a failure occurs, you can use the DSQ1ESQD procedure to delete any already created objects and begin again.

    Message DSQ21662 is an informational message only and does not indicate errors; you can ignore this message and proceed to run the IVPs.