Querying the Sample Data Source

You can now use the Interactive SQL for ODBC tool to execute queries against the Default data source that contains EMP, DEPT, and DIVISION tables. The Interactive SQL for ODBC can be used to execute ad-hoc queries. Refer to the OpenAccess SDK Administrator’s Guide for more information about the Interactive SQL for ODBC tool.

Use the Data Source Name you specified in the previous step as the DSN when using Interactive SQL or other applications.

The following example assumes a DSN DataSourceName has been created in Connecting to the Sample Data Source for the Default server data source.

1. Change to the installation directory.

2. Set up the required environment variables. To execute the shell script:

   • If you are using the Bourne or Korn shell, type:

     . oaodbc.sh (32-bit client)

     . oaodbc64.sh (64-bit client)

   • If you are using the C shell, type:

     source oaodbc.csh (32-bit client)

     source oaodbc64.csh (64-bit client)

3. Change to the tools sub-directory.

4. Execute the one of the following:

   • odbcisql (32-bit client)
   • odbcisql64 (64-bit client)

5. At the ISQL prompt, enter the connect command:

   CONNECT pooh*bear@mydsn

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

   SELECT * FROM emp;

7. From the Interactive SQL prompt, type:

   EXIT