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-5
Usage Techniques
Usage Techniques
When using the NonStop SQL Query Tool and the NonStop SQL Catalog, consider
using the following techniques:
•
You can use bookmarks to save the current NonStop SQL Query Tool and the
current NonStop SQL Catalog. Type a bookmark label in the appropriate box and
click the Prepare to Bookmark button.
•
Whenever reasonable, leave variable values unspecified in your query. When you
submit the query, the Query Tool automatically generates a form to prompt the user
for the variable value. Leaving variable values unspecified increases the generality
of your queries and greatly improves the effectiveness of the SQL statement cache.