Reference Manual
   CHAPTER 9. SQL Statements     

SET OPTION statement [ISQL]

Function 

To change Interactive SQL options.

Syntax 1 

SET [ TEMPORARY ] OPTION
... [ userid. | PUBLIC. ]option-name = [ option-value ]

Syntax 2 

SET PERMANENT

Syntax 3 

SET

Parameters 

userid: identifier, string or host-variable

option-name: identifier, string or host-variable

option-value: host-variable (indicator allowed), string, identifier, or number

See Also 

Interactive SQL options

Description 

SET PERMANENT (syntax 2) stores all current Interactive SQL options in the SYSOPTIONS system table. These settings are automatically established every time Interactive SQL is started for the current user ID.

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