DBISQL options

These options change how DBISQL interacts with the database.

Syntax 1

SET 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

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
AUTO_COMMIT	ON, OFF	OFF
AUTO_REFETCH	ON, OFF	ON
BELL	ON, OFF	ON
COMMAND_DELIMITER	string	';'
COMMIT_ON_EXIT	ON, OFF	ON
DEFAULT_ISQL_ENCODING	identifier or string	empty string (use system code page)
ECHO	ON, OFF	ON
HEADINGS	ON, OFF	ON
INPUT_FORMAT*
ISQL_COMMAND_TIMING	ON, OFF	ON
ISQL_ESCAPE_CHARACTER	single character	\ (backslash)
ISQL_FIELD_SEPARATOR	string	, (comma)
ISQL_LOG	file name	''
ISQL_QUOTE	string	' (single apostrophe)
NULLS	ON, OFF	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	Integer	0
OUTPUT_NULLS	String	'NULL'
STATISTICS	0, 3, 4, 5, 6	3
TRUNCATION_LENGTH	integer	256

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