skip to main content
Configuring the ODBC Client : Using Interactive SQL for ODBC : Example of an Interactive SQL Session
 

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