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 .
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