|
![UltraLite commit_flush_timeout option [temporary]](gif/backward.gif)
Sets the database identification number.
UltraLite employs different methods for setting this property:
| Context | Implemented 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. |
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.
To autoincrement UltraLite database columns from 3001 to 4000, set the global ID to 3.