Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

isql_show_multiple_result_sets [Interactive SQL]

Specifies whether multiple result sets can appear in the Results pane in Interactive SQL.

ON, OFF

OFF

Set this option to ON if you want Interactive SQL to display multiple result sets in the Results pane when you execute a procedure that returns multiple SELECT statements.

Each result set appears on a separate tab in the Results pane. By default, Interactive SQL does not display multiple result sets. The setting of this option also applies to Interactive SQL when it is running in console (command-prompt) mode.

• SET OPTION statement [Interactive SQL]