When replicating INSERT statements from a remote database to a consolidated database, you can only exclude the following columns from the publication:
Columns that allow NULL.
Columns that have defaults.
If you exclude any column that does not satisfy one of these requirements, INSERT statements carried out at a remote database fail when replicated on the consolidated database.
An exception to this example is when a BEFORE trigger is used to maintain the columns that are not included in the INSERT statement.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|