ml_remote_id option

Any value that uniquely identifies the database for MobiLink synchronization.

NULL

Can only be set for PUBLIC. You must have the SET ANY USER DEFINED OPTION system privilege to set this option. Takes effect immediately.

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.

Caution

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'

ml_remote_id option

Allowed values

Default

Scope

Remarks

Caution

See also

Example