Example of an Interactive SQL Session

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:

connect pooh*bear@[fe80::250:56ff:fe83:7290%4]:19988;
ServerDataSource=Default;