isql_print_result_set option [Interactive SQL]

Specifies which result set(s) are printed when a .sql file is run.

Allowed values

LAST, ALL, NONE

Default

LAST

Remarks

The isql_print_result_set option takes effect only when you run Interactive SQL as a command line program (for example, when running a .sql file).

This option allows you to specify which result set(s) are printed when a .sql file is run.

You can choose one of the following print options:

  • LAST   Prints the result set from the last statement in the file.

  • ALL   Prints result sets from each statement in the file which returns a result set.

  • NONE   Does not print any result sets.

Although this option has no effect when Interactive SQL is running in windowed mode, you can still view and set the option in windowed mode. Choose Tools » Options. On the Results tab, select the appropriate action under Console Mode.

See also