The Download Deletes tab applies if the download type is Timestamp. That is, in the Table Mappings pane, the Download Type is set to Timestamp and the Download Deletes column is selected. See Mappings: Table Mappings.
This tab allows you to view and modify the way that the deletions on the consolidated database are recorded for timestamp-based synchronization. The Download Deletes tab shows the following information for the selected table:
Use shadow table to record deletions Select this option if you want to use shadow tables to track deletes in the consolidated database.
Shadow tables are created for each synchronized table in the model. Each shadow table has two columns: one that holds the primary key for the table, and another that holds the timestamp. Shadow tables are created with the same owner as the base table.
Timestamp column name Specifies the name of the TIMESTAMP column. The default Timestamp column name is last_modified.
Use logical deletes Select this option if you want to use logical deletes in the consolidated database to help with download deletes. Logical deletes use a status column to keep track of whether rows are valid. The following options specify how the status column tracks deletes:
Column name Specifies the name of the column that is used to indicate if a row has been deleted. This column is added if it is not already present. The default name is deleted.
Value if row deleted Specifies the value that is generated when a row is deleted. The default is Y.
Value if row not deleted Specifies the value that is generated when a row is not deleted. The default is N.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|