ASA SQL Reference
  SQL Statements

SET OPTION statement [Interactive SQL]

Description 

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

Syntax 1 

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

userid :    identifier, string or hostvar

option-name :  identifier, string or hostvar

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

Syntax 2 

SET PERMANENT

Syntax 3 

SET

Usage 

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.

See Also 

Interactive SQL options