isql_maximum_displayed_rows option [Interactive SQL]

Specifies the maximum number of rows that can appear in the Results pane in Interactive SQL.

Allowed values

ALL or a non-negative integer

Default

500

Remarks

This option lets you specify the maximum number of rows that appear in the Results pane. You can also set the value for this option in the Options window in Interactive SQL.

Caution

Interactive SQL can run out of memory when displaying large result sets. If this problem occurs, Interactive SQL reports the problem but will not display the result set.

See also