ASA Database Administration Guide
  Database Options
    Alphabetical list of options

ISQL_PRINT_RESULT_SET option [ISQL]

Function 

This option 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 DBISQL within a command window (for example, using the -nogui option).

Allowed values 

LAST, ALL, NONE

Default 

LAST

Description 

This option allows you to specify which result set(s) are printed when a .SQL file is run. It is remembered on a per-machine basis (not per-user), and is case-insensitive.

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, then select the appropriate action in the Console Mode box on the Results page. Remember to choose the Make Permanent option if you want to set this option for all Interactive SQL sessions. Otherwise the change will be discarded when you exit Interactive SQL.