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-3
Read-Only Access
Read-Only Access
The NonStop SQL Query Tool and Catalog Explorer support one additional security
feature: the DO_SQL_SELECT_ONLY environment variable, if present, restricts the
available SQL statements to the SELECT statement only, therefore limiting the user to
read-only access. Include this environment variable in the configuration file as follows:
Region /*.atp_sql_query {
AddCGI DO_SQL_SELECT_ONLY 1
}
Using the NonStop SQL Catalog Explorer
The NonStop SQL Catalog Explorer enables you to select from a list of all catalogs on
the system and display catalog contents such as:
•
Tables
•
Views
•
Files
•
Indexes
•
Keys
•
Partitions
•
View text
By specifying an SQL statement type and other characteristics, you can generate a
NonStop SQL query with the Catalog Explorer, then execute the query with the
NonStop SQL Query Tool.
The SQL Catalog Explorer does not attempt to generate all possible SQL syntax but can
save you considerable typing (and typographical errors).
Running the Catalog Explorer
You can run the Catalog Explorer by selecting it from the ATP home page
(/examples/index.html), by choosing the SQL Catalog Explorer Window from
the Query Tool, or by entering the URL /examples/sql_tools/expsql.
The Catalog Explorer includes a quick tour and extensive online help. When using the
Catalog Explorer for the first time, be sure to use these two features.
Note. The sample Catalog Explorer included with iTP ATP is now labelled ATP/SQL Edition
internally and has been derived from a demonstration product of the same name.