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

iTP Active Transaction Pages (iTP ATP) Programmer’s Guide—522292-002
A-1
A
SQL Query Tool and Catalog Explorer
The NonStop SQL Query Tool and Catalog Explorer provide an easy way to generate
queries to cut and paste into your ATP scripts. They also demonstrate a sophisticated use
of direct NonStop SQL access from web pages using ATP.
You can use the Catalog Explorer interactively from your browser to view the contents
and structure of a specified SQL catalog and to generate an SQL query against one or
more tables or views. You can use the Query Tool to test a query that you have typed or
generated with the Catalog Explorer. These applications require the use of Netscape
Navigator 3.01 or later or Internet Explorer 4.0 or later. They can accept and display data
and column headings in kanji, katakana, or hangule if your browser is configured to
support those fonts.
The objects used in the programs are the atp.SQL object for query declaration,
execution, and statistics collection, and the atp.sqlvar object for formatting output
based on the query compilation results. Both programs are located in the directory called
/examples/sql_tools/explorer.
This appendix includes the following subsections:
•
Installing the Tools on page A-1
•
Security on page A-2
•
Using the NonStop SQL Catalog Explorer on page A-3
•
Using the NonStop SQL Query Tool on page A-4
•
Usage Techniques on page A-5
Installing the Tools
The ATP installation procedure automatically configures the Query Tool and Catalog
Explorer to run in the same PATHMON environment as the iTP Secure WebServer.
Alternatively, you could run the tools in a separate PATHMON environment; such a
configuration has security advantages, as described in Security
on page A-2.
If you wish to run the tools in the same PATHMON environment as the WebServer,
there are no additional steps required to install them (except making sure that the
WebServer is running).