The Column Mappings tab lets you see and change the mappings between columns in the consolidated table and the remote table.
You can mark a column mapping for deletion by selecting a row in the Column Mappings tab, right-clicking the column and choosing None. The column mapping is deleted when you save the model.
The Column Mappings tab shows the following information for each column in the consolidated table:
Consolidated column name This is the column that you are synchronizing in the consolidated database.
Consolidated column number This column indicates the order in which columns are returned by a SELECT * FROM tablename statement executed on the consolidated database.
Consolidated column data type The data type of the consolidated column.
Mapping direction The mapping direction of the column.
For consolidated columns that are mapped to remote columns, the mapping direction is either the same as the mapping direction for the table or Not Synchronized. For example, if the table has a bi-directional table mapping, the table's columns can either be Bi-Directional or Not Synchronized. For consolidated columns mapped to expressions, the mapping direction is always upload-only.
If the column mapping direction is Not Synchronized, the column is part of the remote database schema. When the model is deployed, the column is created on the remote, but no information is synchronized to it.
Remote column name Shows the remote column or expression to which the consolidated column is mapped. The column is empty if the consolidated column is not synchronized.
Columns can be mapped to expressions by right clicking the column and selecting MobiLink User Name, Remote ID or Custom. Selecting Custom opens a window where you can enter a SQL expression that can include MobiLink named parameters. Columns in tables whose mapping direction is download-only cannot be mapped to an expression.
Column mappings that involve expressions are always upload-only. Columns involved in these mappings exist in the remote database but are not synchronized. If you map a consolidated primary key column to an expression, you must apply appropriate download subsets and download delete subsets to ensure the uniqueness of primary keys on download.
If your remote database existed before you created your synchronization model, the information in the Remote Column Names column represents a best guess that you should check.
Remote column number This column indicates the order in which columns are returned by a SELECT * FROM tablename statement executed on the remote database.
Remote column data type The data type of the remote column.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0 |