Use this statement to change the values of database options.

Syntax

SET OPTION option-name=option-value

option-name: identifier 

option-value: string, identifier, or number

Remarks

You can only set database options with this statement. Properties cannot be modified after the database has been created.

You cannot specify whether and option is persistent or not. The way an option has been implemented in UltraLite determines whether it is a persistent or temporary option. Persistent options are stored in the sysuldata table. Temporary options are used only until the database stops running.

See also

• sysuldata system table
• Introduction to UltraLite database options
• DB_PROPERTY function [System]

Example

The following statement sets the global_database_id option to 100:

SET OPTION global_database_id=100;