Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

SET OPTION statement Next Page

SET OPTION statement [Interactive SQL]

Use this statement to change the values of Interactive SQL options.

Syntax 1

SET [ TEMPORARY ] OPTION option-name = [ option-value ]

userid : identifier, string, or hostvar

option-name : identifier, string, or hostvar

option-value : string, identifier, or number

Syntax 2


Syntax 3



Syntax 1 stores the specified Interactive SQL option.

Syntax 2 stores all current Interactive SQL options

Syntax 3 displays all of the current database option settings. If there are temporary options set for the database server, these are displayed; otherwise, the permanent option settings are displayed.

Interactive SQL option settings are stored on the client computer. They are not stored in the database.


The syntax SET [ TEMPORARY ] OPTION [ userid | PUBLIC. ]option-name is deprecated. If you specify this syntax, the userid or PUBLIC keyword is ignored.

See also