solidDB Help : solidDB reference : SQL: Statements : MESSAGE : MESSAGE END
  
MESSAGE END
Note Applies to only solidDB Advanced Replication configurations.
MESSAGE unique‑message‑name ENDUsage
Use the MESSAGE END statement to close a message in a replica database. Closing a message means that you can no longer append anything to it. A message must be made persistent before it can be sent to the master database by committing the transaction that contains the message.
The MESSAGE END statement can be executed only on replica databases.
Note When working with messages, autocommit mode must be switched off.
Return values from replica database
 
Error code
Description
13133
Not a valid license for this product
25005
Message message‑name is already active
25013
Message message‑name not found
25018
Illegal message state.
The MESSAGE BEGIN statement must exist to begin a transaction and the MESSAGE END statement can be executed only one time per message.
25026
Not a valid master user
25035
Message message‑name is in use
A user is currently creating or forwarding this message.
25056
Autocommit not allowed
Return values from master database
 
Error code
Description
25019
Database is not a replica database
25056
Autocommit not allowed
Examples
MESSAGE MyMsg001 END; COMMIT WORK;
The following example shows a complete message that propagates transactions and refreshes from publication PUB_CUSTOMERS_BY_AREA.
MESSAGE MyMsg001 BEGIN;
MESSAGE MyMsg001 APPEND PROPAGATE TRANSACTIONS;
MESSAGE MyMsg001 APPEND REFRESH PUB_CUSTOMERS_BY_AREA("OSOUTH');
MESSAGE MyMsg001 END;
COMMIT WORK;
Go up to
MESSAGE