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

See also

• Interactive SQL options
• Using Interactive SQL