DBISQL options

These options change how DBISQL 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.

SET PERMANENT (Syntax 2) stores all current DBISQL options in the SYSOPTIONS system table. These settings are automatically established every time DBISQL 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 DBISQL or the database server, these are displayed; otherwise, the permanent option settings are displayed.

Table 2-4 lists the DBISQL options, their allowed values, and their default settings.

See “General database options” and “Transact-SQL compatibility options” for lists of the other classes of options.

Table 2-4: DBISQL options

Option

Values

Default

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

NoteAn asterisk (*) next to the option name in Table 2-4 indicates an option currently not supported by Sybase IQ.