This page allows you to specify the information required to subset data by MobiLink user name. To use this option the MobiLink user names must be on your consolidated database. 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.) If the MobiLink user names are in a different table from the one you are subsetting, you must join to that table. For example, you can join columns containing first names and last names.
This page has the following components:
Use a column in each downloaded table For downloaded tables that include the specified column, each row is downloaded by only one MobiLink user. For tables that are also uploaded, you must either synchronize the column or define a default value for it.
Column name Choose a column name from the dropdown list. The dropdown list contains all the compatible columns from the synchronized consolidated tables.
Use a column in a joined relationship table If the MobiLink user names are in a different table from the one you are subsetting, you must join to that table. For an example of when to use this option, see the example below. Specify the following information for the join:
Table to join Choose a table from the dropdown list. This table is joined to each synchronized table that has the column specified below.
Column to match Choose a column from the dropdown list of compatible columns.
Choose the columns for joining each downloaded table T with the relationship table in the following join condition Choose a column from each dropdown list to specify how the tables are to be joined.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|