iTP Active Transaction Pages (iTP ATP) Programmer's Guide

SQL Query Tool and Catalog Explorer
iTP Active Transaction Pages (iTP ATP) Programmer’s Guide—522292-002
A-4
Using the NonStop SQL Query Tool
Using the NonStop SQL Query Tool
The NonStop SQL Query Tool enables you to either type an SQL query or use a query
generated by the Catalog Explorer.
Running the Query Tool
You can run the Query Tool by navigating to it from the ATP home page
(/examples/index.html), by submitting a query from the Catalog Explorer, or by
retrieving a bookmarked query from an earlier session.
Entering a Query
To enter a query, you can type it, retrieve it from a bookmark, paste or submit it from the
Catalog Explorer. If the query requires parameters (represented by question marks in the
query), the Query Tool displays a form to prompt you for each parameter.
Choosing Display Options
Use the radio buttons to indicate whether to use TMF and to specify any of the following
output styles:
•
Table style (to present the data in columns)
•
Form style (to present each row as a separate table)
•
Comma-separated values (for downloading and importing into applications such as
Microsoft Excel)
Use the text boxes to specify the starting row to display and the maximum number of
rows to display.
To bookmark a query in your browser, enter the bookmark label in the text box, then
click the Prepare to Bookmark button. All query options are retained with the query.
Submitting the Query
To submit the query, click on the Submit button. To clear the window, click on the Reset
button. To open a new Query window, click on the New Query button.
You can also use the Query Tool to generate a file that gives Excel access to query
results without needing a browser. Click on Excel97 iqy File to display instructions for
creating such a file.