Unique, non-negative integer

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.

To maintain primary key uniqueness when synchronizing with a MobiLink server, the global ID sets a starting value for GLOBAL AUTOINCREMENT columns. The global ID must be set before default values can be assigned. If a row is added to a table and does not have a value set already, UltraLite generates a value for the column by combining the global_database_id value and the partition size.

When this option is set, UltraLite performs a commit.

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.

To set the global_database_id option from a client application, use the set database option function for the programming interface you are using or use the SET OPTION SQL statement.

• Using GLOBAL AUTOINCREMENT
• Accessing database options
• SET OPTION statement [UltraLite]
• Using GLOBAL AUTOINCREMENT in UltraLite
• ULConnection.SetDatabaseOptionInt method [UltraLite C++]
• ULSetDatabaseID method [UltraLite Embedded SQL]
• ULConnection.DatabaseID property [UltraLite.NET]
• Connection.setDatabaseID method [UltraLite for M-Business Anywhere]
• Connection.setDatabaseId method [UltraLiteJ]
• Connection.OPTION_DATABASE_ID variable [BlackBerry] [UltraLiteJ]

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

SET OPTION global_database_id=3;