Sets the remote ID for a remote database in a MobiLink synchronization system.
Any value that uniquely identifies the database for MobiLink synchronization.
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY USER DEFINED OPTION||Yes||Yes, with SET ANY USER DEFINED OPTION|
|Allowed to set temporarily?||No||No||No|
MobiLink synchronization uses the PUBLIC role setting only.
This option assigns a remote ID for a remote database in a MobiLink synchronization system. The remote ID must be unique within your synchronization system.
If you set the remote ID manually and you subsequently recreate the remote database, you must either give the recreated remote database a different name from the old one or use the ml_reset_sync_state stored procedure to reset the state information in the consolidated database for the remote database.
The safest time to change the remote ID is before the first synchronization. If you change it later, be sure you have performed a complete, successful synchronization just before changing the remote ID. Otherwise you may lose data and put your database into an inconsistent state.
The following SQL statement sets the remote ID to the value HR001:
SET OPTION PUBLIC.ml_remote_id = 'HR001'