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.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |