Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » Referential integrity errors


Insert errors

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.

The uploaded insert fails because of missing columns.
Using BEFORE triggers as an alternative

An exception to this example is when a BEFORE trigger is used to maintain the columns that are not included in the INSERT statement.

 See also