Use this statement to change the values of database options.
SET OPTION option-name=option-value
option-value: string, identifier, or number
You can only set database options with this statement and properties cannot be modified after the database has been created. The exception to these rules isml_remote_id (see below).
You cannot specify whether an 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.
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.
The following statement sets the global_database_id option to 100:
SET OPTION global_database_id=100;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|