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

The isql_show_multiple_result_sets option also appears as the Show All Result Sets option when running Interactive SQL as a windowed application. See Returning multiple result sets.

When deploying Interactive SQL, you can prevent users from setting isql_show_multiple_result_sets option. See showMultipleResultSets.

• SET OPTION statement [Interactive SQL]

Executing the following statement sets the isql_show_multiple_result_sets to On.

SET OPTION isql_show_multiple_result_sets=On

To test the procedure ListPeople and view multiple result sets in Interactive SQL, execute the following statement in Interactive SQL:

SET OPTION isql_show_multiple_result_sets=On;
CALL ListPeople ();