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

Allowed values

On, Off

Default

Off

Remarks

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 as a command line program.

See also

• SET OPTION statement [Interactive SQL]