The Download Subset tab applies if you subset data by user, remote ID, or by a custom subset.
For subset by user or remote ID, the Download Subset tab shows the following information for the selected table mapping:
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.
Custom For a custom download subset, the Download Subset tab shows the following information for the selected table mappings.
Tables to add to the download cursor's FROM clause Type the table name(s) if your download_cursor requires a join to other tables. If the join requires multiple tables, separate them with commas.
SQL Expression to use in the download cursor's WHERE clause Type the SQL expression. By default the same expression and joined tables are used for the download delete subset. If you are using a shadow table for deletes and want to use the same expression, avoid using the base table name in the expression. If that is not possible, use a custom download delete subset.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|