The MobiLink server is able to synchronize two-dimensional, three-dimensional and four-dimensional spatial data between the consolidated and remote databases if the consolidated database is running on a SQL Anywhere server. However, the MobiLink server is only able to synchronize two-dimensional data between the consolidated and remote databases if the consolidated database is one of the other supported RDBMS types.

If an upload stream contains three-dimensional and/or four-dimensional dimensional spatial data and the consolidated database is running on a non-SQL Anywhere database server, the MobiLink server generates a warning message and then drops the third and/or fourth dimension value before sending the spatial data to the consolidated database.

The MobiLink server does not automatically find a mapping between the SRIDs used in the consolidated and remote databases. You must make sure that either the SRIDs used in the remote databases match those defined in the consolidated databases, or user defined upload and download table scripts must be able to convert the SRIDs back and forth between the SRIDs defined in the consolidated and remote databases.

Upload table scripts can be written using named parameters or question marks (?). The use of question marks for SQL scripts is deprecated and it is recommended that you use named parameters. If question marks are used, each spatial column must contain two questions marks. The first one is for the WKB value and the second is for the SRID value.

If named parameters are used, the named parameters must have the following convention:

{ml r.column_name:data}

{ml r.column_name:srid}

The first named parameter represents the WKB value and the second named parameter is for the SRID.

• Introduction to spatial data
• Named script parameters
• User-defined named parameters