Example of an ISQL Session

A typical ISQL session for the ODBC Client uses the following sequence:

1. Start the ISQL tool. Do one of the following:

• On Windows, select Start / Programs, and select Progress DataDirect OpenAccess Client for ODBC SDK 81 / Interactive SQL (ODBC).

• On all platforms, from a command prompt, change to the subdirectory where the ISQL client program is installed. Typically, this is install_dir.

The Interactive SQL prompt appears.

2. Connect to the sample data source test_servername. Type:

CONNECT test_servername;

3. Issue a SQL command to query or modify the data source. For example:

SELECT * FROM emp;

4. Disconnect from the data source. Type:

DISCONNECT;

5. Exit from the ISQL program. Type:

EXIT

For detailed information about the ISQL tools for each client, refer to the OpenAccess SDK Administrator’s Guide.