solidDB Help : solidDB reference : SQL: Statements : MESSAGE : MESSAGE DELETE
  
MESSAGE DELETE
Note Applies to only solidDB Advanced Replication configurations.
MESSAGE message‑name [FROM REPLICA replica‑name] DELETE
Access requirements
▪ In master database: DBA or SYS_SYNC_ADMIN_ROLE
▪ In replica database: SYS_SYNC_ADMIN_ROLE
Usage
Use the MESSAGE DELETE statement to delete a message from the database to recover from an error. For example, the execution of a message can be terminated because of an error.
The MESSAGE DELETE statement can be executed both on the master and replica databases.
Note When you use the MESSAGE DELETE statement, the current transaction and all subsequent transactions that were propagated to the master database in the message are permanently lost. As an alternative, the MESSAGE DELETE CURRENT TRANSACTION statement can provide better recovery because you can delete only the offending transaction, see MESSAGE FROM REPLICA DELETE CURRENT TRANSACTION.
When deleting messages, autocommit mode must be switched off.
Parameters, clauses, keywords, and variables
▪ FROM REPLICA: Specifies the node name of the replica database (required when MESSAGE DELETE is executed on the master database).
Return values from replica database
 
Error code
Description
25005
Message message‑name is already active
25013
Message message‑name not found
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
13047
No privilege for operation
25009
Replica replica‑name not found
25013
Message message‑name not found
25020
Database is not a master database
25035
Message message‑name is in use.
A user is currently executing this message.
25056
Autocommit not allowed
Examples
MESSAGE MyMsg0000 DELETE;
MESSAGE MyMsg0001 FROM REPLICA bills_laptop DELETE;
Go up to
MESSAGE