The MESSAGE APPEND PROPAGATE TRANSACTIONS statement lets you propagate transactions from a replica to the master database. Only statements that have been explicitly put to the replica database’s transaction queue with the SAVE <sql-statement> statement, can be propagated. The syntax is:

Use the WHERE clause to propagate only those transactions where the property_name meets specific criteria. You can set a property to a currently active transaction in the replica database with the SAVE PROPERTY statement. Use the keyword ALL to propagate all statements, including those with no properties.

The keyword ALL overrides any default propagation condition that may have been set earlier with the SAVE DEFAULT PROPAGATE PROPERTY WHERE command. This command is used to make parameters available to other statements in the transaction on the Parameter Bulletin Board.