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

SQL Anywhere 17 » MobiLink - Server Administration » MobiLink reference

MobiLink server system procedures

MobiLink provides the following stored procedures to help you create your applications.

System procedures to add or delete scripts

You must add synchronization scripts to system tables in the consolidated database before you can use them. The following system procedures add or delete synchronization scripts in the consolidated database:

  • ml_add_connection_script system procedure
  • ml_add_table_script system procedure
  • ml_add_dnet_connection_script system procedure
  • ml_add_dnet_table_script system procedure
  • ml_add_java_connection_script system procedure
  • ml_add_java_table_script system procedure

When you use the MobiLink server API for Java or .NET, you use these stored procedures to register a method as the script for an event, so that the method is run when the event occurs. You can also use them to unregister your methods.

When you add a script using a system procedure, the script is a string. Any strings within the script need to be escaped. For SQL Anywhere, each quotation mark (') needs to be doubled so as not to terminate the string.

You cannot use system procedures to add scripts longer than 255 bytes to Adaptive Server Enterprise 11.5 or earlier. Instead, use SQL Central or direct insertion to define longer scripts.

IBM DB2 LUW before version 6 only supports column names and other identifiers of 18 characters or less, and so the names are truncated. For example, ml_add_connection_script is shortened to ml_add_connection_.

System procedures for managing remote tasks

The following stored procedures can be used to manage remote tasks:

  • ml_ra_add_agent_id system procedure
  • ml_ra_assign_task system procedure
  • ml_ra_cancel_notification system procedure
  • ml_ra_cancel_task_instance system procedure
  • ml_ra_clone_agent_properties system procedure
  • ml_ra_delete_agent_id system procedure
  • ml_ra_delete_events_before system procedure
  • ml_ra_delete_remote_id system procedure
  • ml_ra_delete_task system procedure
  • ml_ra_get_agent_events system procedure
  • ml_ra_get_agent_ids system procedure
  • ml_ra_get_agent_properties system procedure
  • ml_ra_get_latest_event_id system procedure
  • ml_ra_get_orphan_taskdbs system procedure
  • ml_ra_reassign_taskdb system procedure
  • ml_ra_get_remote_ids system procedure
  • ml_ra_get_task_results system procedure
  • ml_ra_get_task_status system procedure
  • ml_ra_manage_remote_db system procedure
  • ml_ra_notify_agent_sync system procedure
  • ml_ra_set_agent_property system procedure
  • ml_ra_unmanage_remote_db system procedure
LDAP system procedures

The following stored procedures can be used to setup and manage LDAP authentication:

  • ml_add_certificates_file system procedure
  • ml_add_ldap_server system procedure
  • ml_add_user_auth_policy system procedure
Synchronization model system procedures

The following stored procedures can be used to manage schema upgrades:

  • ml_model_drop system procedure
  • ml_model_check_all_schema system procedure
  • ml_model_check_version_schema system procedure
Other system procedures
  • ml_add_property system procedure
  • ml_delete_sync_state_before system procedure
  • ml_reset_sync_state system procedure