SQL Anywhere® Server - Database Administration  > SQL Anywhere Administration Tools  > Interactive SQL  > Interactive SQL options

isql_print_result_set option [Interactive SQL]

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

The isql_print_result_set option takes effect only when you run the Interactive SQL (dbisql) utility within a command window (for example, when running a .sql file).

LAST, ALL, NONE

LAST

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 affect 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 in the Console Mode area.

• SET OPTION statement [Interactive SQL]