Contents Index Declaring default global autoincrement Setting unique database identification numbers when extracting databases

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Anywhere
    Ensuring unique primary keys
      Using global autoincrement default column values

Setting the Global_database_id value

When deploying an application, you must assign a different identification number to each database. You can accomplish the task of creating and distributing the identification numbers by a variety of means. One method is to place the values in a table and download the correct row to each database based on some other unique property, such as user name.

To set the global database identification number

For example, the following statement sets the database identification number to 20.

SET OPTION PUBLIC.Global_database_id = 20

If the partition size for a particular column is 5000, default values for this database are selected from the range 100001-105000.


Contents Index Declaring default global autoincrement Setting unique database identification numbers when extracting databases