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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable options in UltraLite

UltraLite commit_flush_timeout option [temporary] Next Page

UltraLite global_database_id option

Sets the database identification number.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use the ulinfo utility.

Use the following utility option:

-g ID

From Sybase Central    Use the Database Options dialog by right-clicking the database name and choosing Options.

Select the global_database_ID option and type a new string in the Value field below the options table.

With SQL    Use the SET OPTION statement.

Use the following statement syntax:

SET OPTION global_database_id=ID

From a client application    Use the set database ID method.

The method of setting this identification number varies according to the programming interface you are using.

Allowed values

The global database identifier in each deployed UltraLite application must be set to a unique, non-negative integer before default values can be assigned. These identification numbers uniquely identify the databases.


The range of default values for a particular global autoincrement column is pn + 1 to p(n + 1), where p is the partition size of the column and n is the global database identification number.


When deploying an application, you must assign a different identification number to each database for synchronization with the MobiLink server.

You can change the global ID of an existing database at any time. You do not need to create a new database.

See also

To autoincrement UltraLite database columns from 3001 to 4000, set the global ID to 3.