QMF & SPUFI

QMF

          Description: QMF = Query Management Facility                             

                                                                          

An IBM database management tool that allows extensive interactive query and report writing support.  It runs     under the control of the Interactive System Productivity  Facility (ISPF), which in turn runs under Virtual Machine   (VM/CMS) or Time Sharing Option (TSO) on host computers.

     SPUFI

              Description: SPUFI = SQL Processing Using File Input                    

A facility of the TSO attachment subcomponent that enables   the DB2I user to execute SQL statements without embedding   them in an application program.

–        SPUFI requires that SQL statements to be executed be stored

        in a data set. One way to use SPUFI is to create the data set prior to executing

–        SPUFI.  We can make any desired changes to the data set using editing

        facilities provided by SPUFI before executing the statements stored in it.

–        Alternatively, we can begin a SPUFI session and use the editing facilities of SPUFI to create a data set into which we can place our SQL statements.

–        As SQL statements are processed by SPUFI, the results they generate

        are stored in a data set. The stored data includes a copy of each SQL

    statement followed by its results.

–        For a SELECT statement, the results include both the data retrieved and the value of SQLCODE that is returned.

–        By invoking the BROWSE option, we can cause the output data set to be displayed on the terminal. We can use the ISPF browse facilities to

    move around within the displayed data.

–        SPUFI also provides limited formatting options that we can use to

    specify how the data in the output data set is displayed or printed.

        These formatting options can be set using the SPUFI defaults panel.