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

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Creating SQL Remote systems » Unique identification numbers for remote databases

 

Setting the global_database_id value

Set an identification number for remote databases.

Prerequisites

There are no prerequisites for this task.

Context and remarks

The identification number must be a non-negative integer.

 Task
  • Set the value of the global_database_id option.

    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.

Results

The global_database_id number is set.

 See also