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.
- Click Tools > Options in the Interactive SQL window.
The Interactive SQL Options window appears.
- On the SAP Sybase IQ page, select
the Results tab.
- Choose Show all Result Sets.
- Click OK.