Use this statement to change the values of Interactive SQL options.
SET OPTION option-name = [ option-value ] | SET TEMPORARY OPTION option-name = [ option-value ]
option-name : identifier, string, or hostvar
option-value : string, identifier, or number
By default, when you set an option using the SET OPTION syntax, the option setting is stored permanently and does not change unless another SET OPTION statement changes it.
Using the SET TEMPORARY OPTION syntax allows you to temporarily change an option setting. The temporary setting remains in effect until you close Interactive SQL. The next time you start Interactive SQL, the option reverts to its permanent setting.
Use the SET PERMANENT syntax to permanently save all current Interactive SQL option settings (any temporary settings become permanent).
Use Syntax 3 to display all the current database option settings. If there are temporary options settings for the database server, these are displayed instead of the permanent settings.
Interactive SQL option settings are stored on the client computer, not in the database.
For descriptions of the current Interactive SQL options, see Interactive SQL options.
SQL/2003 Vendor extension.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|