To view relational database SQL statements in InfoNaut

Relational databases that can be used with InfoNaut include Oracle, Oracle Rdb, IBM DB2, Microsoft SQL Server, Sybase, and Informix, although there are others available through the CONNX OLE DB and ODBC Desktop and Enterprise adapters.

 

1. Click the Start button, and then point to All Programs. Point to CONNX Driver, and then click InfoNaut - The CONNX Query Tool. The main InfoNaut window opens.
 

Initial_Infonaut_screen.bmp

 

2. Add a connection to a data source.

3. Create a query. Click the Relational Database SQL button, and then click the Execute button to view the relational database SQL statement.

Relational_DB_SQL_button.bmp

Execute_button.bmp

4. The SQL statement appears in the lower pane.

Relational_DB_SQL_screen.bmp

5. Click the Data button and the Execute button again in order to return to viewing the contents of the database.

 

Data_button.bmp

 

Execute_button.bmp