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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (P-Z)

 

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 ]
option-name : identifier, string, or hostvar
option-value : string, identifier, or number
Syntax 2
SET PERMANENT
Syntax 3
SET
Remarks

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.

Standards and compatibility
  • SQL/2003   Vendor extension.

See also