SET OPTION statement [Interactive SQL]

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

Syntax 1 - Set an option

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

Syntax 2 - Save current options permanently

SET PERMANENT

Syntax 3 - Review current options

SET

Remarks

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.

Standards and compatibility

SQL/2003 Vendor extension.