CLI Reference Guide

ODBCLink/SE Reference Manual Using ODBCLink/SE With ODBC Applications
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 39
Select Catalog, New. Enter a catalog name and your logical database name (HP3000-1). Impromptu should then
establish the connection and put you into the Edit Tables Screen.
The left side of the Edit Tables screen is a list of table owners. In ALLBASE/SQL, a table owner is the owner name
assigned by the database administrator (default is UserAccount). For a TurboIMAGE dataset, the owner name is the
database name. To get a list of all the tables for a specific owner name, double click it.
You may now select the tables you want included in your catalog. After you click OK, Impromptu will load the table
definition into the catalog.
If you want to add tables from another database to your catalog, select Catalog, Edit Tables, and follow the same
procedure again.
You may now create a report through the File, New command. You will be prompted for the fields to include in your
report, and Impromptu will generate the report on your screen.
Note: You cannot create summary reports on TurboIMAGE tables
with this version of the driver. The GROUP BY command is
not implemented. You can, however, group rows and
compute subtotals.
Special Notes for Users of Impromptu
Viewing the SQL generated by Impromptu
Enter a new report and select Report, Query, Profile, View SQL. You can also write your own SQL and override that
generated by Impromptu. Search for help on topic
AWriting your own SQL@.