Interactive SQL Options

Interactive SQL options change how Interactive SQL interacts with the database.

Syntax 1

SETTEMPORARY ] OPTION
... [ userid. | PUBLIC. ]option-name = [ option-value ]

Syntax 2

SET PERMANENT

Syntax 3

SET

Parameters

userid:
identifier, string or host-variable
option-name:
identifier, string or host-variable
option-value:
host-variable (indicator allowed), string, identifier,
or number

Description

Syntax 1 with the TEMPORARY keyword cannot be used between the BEGIN and END keywords of a compound statement.

Syntax 2 SET PERMANENT stores all current Interactive SQL options in the SYSOPTIONS system table. These settings are automatically established every time Interactive SQL is started for the current user ID.

Syntax 3 is used to display all of the current option settings. If there are temporary options set for Interactive SQL or the database server, these are displayed; otherwise, the permanent option settings are displayed.

Interactive SQL Options

Option

Allowed values

Default setting

DEFAULT_ISQL_ENCODING

Identifier or string

empty string (use system code page)

NULLS*

String

NULL

ON_ERROR

STOP, CONTINUE, PROMPT, EXIT, NOTIFY_CONTINUE, NOTIFY_STOP, NOTIFY_EXIT

PROMPT

OUTPUT_FORMAT*

ASCII, DBASEII, DBASEIII, EXCEL, FIXED, FOXPRO, HTML, LOTUS, SQL, XML,

ASCII

OUTPUT_LENGTH*

Non-negative integer

0 (no truncation)

OUTPUT_NULLS*

String

'NULL'

STATISTICS*

0, 3, 4, 5, 6

3

TRUNCATION_LENGTH*

Integer

256

Note: An asterisk (*) next to the option name indicates an option currently not supported by Sybase IQ.
Related concepts
General Database Options
Transact-SQL Compatibility Options
Alphabetical List of Options