A typical ISQL session uses the following sequence:
1. Start the ISQL tool. Do one of the following:
On Windows, double-click the jdbcisql.bat file in the install_dir\isql folder. Or, from a command prompt, change to the install_dir\isql folder and run the jdbcisql.bat file.
On Linux and UNIX, change to the install_dir\isql directory and run jdbcisql.sh.
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
Note that the JDBC client supports the use of IPv6 addresses in JDBCISQL. For example:
On Windows, double-click the jdbcisql.bat file in the install_dir\isql folder. Or, from a command prompt, change to the install_dir\isql folder and run the jdbcisql.bat file.
