Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite SQL reference » UltraLite SQL statements

SET OPTION statement [UltraLite]

Changes the values of database options.

SET OPTION option-name=[option-value]
option-name: identifier 
option-value: string, identifier, or number

This statement allows you to set options on an UltraLite database. Most UltraLite options are set when the database is initially created and cannot be modified afterward.

You cannot specify whether an option is persistent or not. UltraLite determines whether it is a persistent or temporary option. Persistent options are stored in the database. Temporary options are used only until the connection or database stops running.

UltraLite performs a commit when persistent options are set: global_database_id and ml_remote_id. UltraLite does not perform a commit on temporary or connection-based options.

The only database option that can be unset is ml_remote_id. For example:

SET OPTION ml_remote_id=

The result is that the ID is set to NULL. When this occurs, UltraLite will automatically generate a new value at the next synchronization.


The following statement sets the global_database_id option to 100:

SET OPTION global_database_id=100