Interactive SQL Options

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

Syntax 1

SET [ TEMPORARY ] 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.