ODBCLink/SE Reference Manual

Using ODBCLink/SE With ODBC Applications

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@.

ODBCLink/SE

 

©M.B. Foster Associates Limited 1995-2000

39

Page 49
Image 49
HP MPE/iX 6.x Operating System manual Special Notes for Users of Impromptu, Viewing the SQL generated by Impromptu