DB2 graphic QMF Version 8

Exit Routine

An exit point is taken after Query Analyzer has produced the raw analysis data. The analysis data is passed to the Query Analyzer exit routine (a REXX program named RAARXQA), where you can specify whether the query should run or be canceled.

This exit routine specifies which ISPF panel to display to the user. A pre-defined panel is (and associated help panels are) shipped with Query Analyzer, but you can create your own and display it instead.

Additionally, all tables found in the access path information are passed to this exit routine. This allows you to cancel queries based on the tables that are referenced and accessed.

The exit routine can also limit the number of rows that the query should return. This "Top-10" feature tells QMF to return only the first n-rows of an answer set before the query runs.

The exit routine provided uses the REXX language for easy programming and modification.


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