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

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » Assigning unique identification numbers to each database


Setting the global_database_id value

 To set the global database identification number (SQL)
  • Set the value of the global_database_id option. The identification number must be a non-negative integer.

    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.

 See also