Example of an Interactive SQL 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 SDK Client for ODBC 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