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

SET PERMANENT

SET

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).

If option-value is omitted, the specified option is set to its default value.

Use Syntax 3 to display all the current database option settings in a window. If there are temporary options settings for the database server, they are displayed instead of the permanent settings.

Interactive SQL option settings are stored on the client computer, not in the database.

The following table lists the Interactive SQL options.

• Interactive SQL options
• Using Interactive SQL

The following statement changes the value of the on_error option:

SET OPTION on_error='continue';