Using the ODBC Client : Interactive SQL for ODBC

Interactive SQL for ODBC

Interactive SQL is an OpenAccess SDK client program used to access OpenAccess SDK data sources. The program supports a command line interface to connect to a data source, execute SQL statements, and retrieve results for display on a terminal.

The driver name specified in the command line option allows the driver to connect to OpenAccess SDK data sources that are served by OpenAccess SDK servers.

The command format to run a SQL statement to query or modify a data source is a SQL statement terminated by a semicolon:

ISQL> SQLstatement ;

A typical ISQL session uses the following sequence:

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

• On Windows, select Start / Programs / Progress DataDirect OpenAccess Client for ODBC 64-bit SDK 8.1. Then, select Interactive SQL.

• 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 using ISQL for ODBC, refer to the OpenAccess SDK Administrator’s Guide.