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

SQL Anywhere 12.0.0 » Context-Sensitive Help » MobiLink Plug-in help » Mappings tab » Mappings: Details

 

Download Subset tab

The Download Subset tab applies if you subset data by user, remote ID, or by a custom subset. The Download Subset tab shows the following information for the selected table:

  • Use a column in the consolidated table   Select this option to use a column in each consolidated table. To use this option, you must have a table on your consolidated database that contains MobiLink user names, or tables that you can join to create MobiLink user names. You choose your MobiLink user names when you deploy, so you can choose names that match existing values on your consolidated database. (The column you use for MobiLink user names must be of a type that can hold the values you are using for the user name.)

    • Column name   Specify a column containing the MobiLink user name or remote ID.

  • Use a column in a joined relationship table   Select this option and identify the MobiLink user name or remote ID with a join. You can specify:

    • Table to join   Specify a column from the consolidated table.

    • Column to match   Specify a column from the chosen table to join.

    • Join condition   Create a join condition by choosing a column from the table chosen in the Table Mappings pane and choosing a column from the table specified in the Table to Join field above.

    See Remote IDs, and Introduction to MobiLink users.

  • Custom   If you chose to create a custom subset, the Download Subset tab allows you to specify tables and an expression. Multiple tables must be separated by commas.

    • Tables to add to the download cursor's FROM clause   Type the table names.

    • SQL Expression to use in the download cursor's WHERE clause   Type the SQL expression.

See Writing download_cursor scripts, and Modifying the download subset.