Querying the Sample Data Source

You can now use the Interactive SQL for ODBC tool to execute queries against the Default data source. The Interactive SQL for ODBC tool can be used to execute ad-hoc queries. Refer to the OpenAccess SDK Administrator’s Guide for more information.

The following sample session for Windows that assumes the mydsn data source has been created for the Default data source. Use the data source name you specified in Connecting to the Sample Data Source as the DSN when using Interactive SQL or other applications.

1. From the Progress DataDirect OpenAccess SDK 8.1 / Local Client for ODBC and IP SDK program group, select Interactive SQL (ODBC).

2. From the Interactive SQL prompt, type:

   ISQL> CONNECT pooh*bear@mydsn

3. From the Interactive SQL prompt, enter in a SQL query. For example, type:

   ISQL> SELECT * FROM emp;

4. From the Interactive SQL prompt, type:

   ISQL> EXIT