Querying the Sample Data Source

Use the Interactive SQL for JDBC tool (jdbcisql) to execute queries against the Default server data source. Refer to the OpenAccess SDK Administrator’s Guide for detailed information on using the Interactive SQL for JDBC tool.

The following example assumes an OpenAccess SDK Server running on host mysdkserver at port 20092 and is configured with a Default server data source.

1. Change the directory to *install_dir*\isql.

2. From a command prompt, run the command jdbcisql to set the required CLASSPATH and launch the jdbcisql.jar Java program.

3. From the Interactive SQL prompt, type the following command to connect to your data source.

   ISQL> CONNECT pooh*bear@mydsn:20092;ServerDataSource=Default;

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

   ISQL> SELECT * FROM emp;

5. From the Interactive SQL prompt, type:

   ISQL> EXIT