Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

I've generated a sample Mobilink project via the graphical wizard and obtained the cons_setup.sql and remote_setup.sql scripts. I can see that they're using a bunch of ml_* procedures/functions:

  • where are these documented on I managed to find the MobiLink server system procedures section, and can see a whole bunch of ml_* procedures documented there, but none of the ones that are used in the two SQL scripts above!
  • Starting from scratch and without the GUI, how does one install all the ml_* related tables and procs in a consolidated DB? Where is all of this documented?

Related to

asked 09 Sep '20, 03:42

saurabhnanda's gravatar image

accept rate: 0%

edited 09 Sep '20, 03:43


For your reference, MobiLink existed long before the wizard, and no part of the wizard is required for MobiLink.

All the remote database MobiLink system objects are built in to every SQL Anywhere 17 database.

All the consolidated database MobiLink system objects must be installed by running the script in C:\Program Files\SQL Anywhere 17\MobiLink\Setup that matches the RDBMS running your consolidated database.

(09 Sep '20, 08:50) Breck Carter

See the docs for the according consolidated databases, to cite:

To set up a database so that it can be used as a MobiLink consolidated database, you must run a setup script. Your SQL Anywhere installation includes a script for each of the supported RDBMSs. These scripts are all located in %SQLANY17%\MobiLink\setup.

I cannot check this currently but IIRC the scripts should define those ML objects. And of course the scripts to define those vary for the different consolidated databases types.

permanent link

answered 09 Sep '20, 06:18

Volker%20Barth's gravatar image

Volker Barth
accept rate: 34%

edited 09 Sep '20, 06:20

do you know where the ml_* function are documented?

(09 Sep '20, 09:52) saurabhnanda
Replies hidden

They are described in great detail in Parts of a MobiLink application".

The MobiLink consolidated architecture is event driven, so the ml_* procedures are referred to as event handlers, as in "SQL row handlers", also called "table events".

Here's an example of the detailed docs: download_cursor table event

For more information about how ml_add_table_script works, see the actual code in C:\Program Files\SQL Anywhere 17\MobiLink\Setup

(09 Sep '20, 15:16) Breck Carter
permanent link

answered 09 Sep '20, 09:56

Reg%20Domaratzki's gravatar image

Reg Domaratzki
accept rate: 36%

Am I hitting a blind spot, or are the following functions, being used by the auto-generated script not present in that section? - ml_model_register_schema_use, ml_model_get_schema_action, ml_add_lang_conn_script_chk, and so on...

(09 Sep '20, 09:59) saurabhnanda

The ML system stored procedures added to support the MobiLink modeling wizard in SQL Central are intended only to be used by SQL Central and are not documented.

(09 Sep '20, 10:06) Reg Domaratzki
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Sep '20, 03:42

question was seen: 921 times

last updated: 09 Sep '20, 15:20