Show multiple results sets in Interactive SQL -nogui mode [CR #633140]

These topics were added to Utility Guide > Using Interactive SQL:

By default, Interactive SQL shows the first result set of the most-recently executed statement. Use this procedure to see all result sets on UNIX platforms.

1. If running Interactive SQL as a command line program (-nogui mode), navigate to your $HOME directory and locate the file .isqlPreferences11.

   1. Change the line

      <entry key="SybaseIQ.showMultipleResultSets">0</entry>
      

      to:

      <entry key="SybaseIQ.showMultipleResultSets">1</entry>
      

   2. Save your changes to .isqlPreferences11.

2. If using GUI mode, click Tools > Options in the Interactive SQL window. The Interactive SQL Options window appears.

   1. On the Sybase IQ page, select the Results tab.

   2. Choose Show All Result Sets.

   3. Click OK.

By default, Interactive SQL shows the first result set of the most-recently executed statement. Use this procedure to see all result sets on Windows platforms.

Setting the Show Multiple Result Sets option in GUI mode also enables multiple result sets in -nogui mode.

1. Click Tools > Options in the Interactive SQL window. The Interactive SQL Options window appears.

2. On the SQL Anywhere page, select the Results tab.

3. Choose Show all Result Sets.

4. Click OK.