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

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite as a MobiLink Client » UltraLite synchronization parameters and network protocol options » Synchronization parameters for UltraLite

 

Table Order synchronization parameter

Sets the table order required for priority synchronization if the UltraLite default table ordering is not suitable for your deployment.

Syntax

This parameter is specified in the additional_parms field in the synchronization parameters. The syntax varies depending on the API you use. You can also set this parameter with ulsync.

Default

If not specified, order tables based on foreign keys relationships.

Allowed values

A comma separated list of table names that lists all tables to be uploaded.

Remarks

Typically, the default is acceptable when the foreign keys on your consolidated database match the UltraLite remote and there are no foreign key cycles.

Quote tables names with either single or double quotes. For example, "Customer,Sales" and 'Customer,Sales' are both supported in UltraLite. With ulsync, you must separate table names with semicolons (;).

If you include tables that are not included in the synchronization, they are ignored.

The order of tables on the download is the same as those you define for upload.

You only need to explicitly set the table order if your UltraLite tables:

  • Are part of foreign key cycles. You must then list all tables that are part of a cycle.
  • Have different foreign key relationships in the consolidated database.
Note

Any tables that you do not list are appropriately sorted based on the foreign keys defined in the remote database.

See also
Examples

ulsync can set this parameter as an extended synchronization parameter as follows:

ulsync -c DBF=myuldb.udb "MobiLinkUid=remoteA;ScriptVersion=2;TableOrder=Customer,Sales;Stream=http"

UltraLite for C/C++ applications can set the parameter as follows:

ul_synch_info info;
// ...
info.additional_parms = UL_TEXT( "TableOrder=Customer,Sales" );