SQL Guide : solidDB® SQL statements : SAVE PROPERTY
  
SAVE PROPERTY
SAVE PROPERTY property_name VALUE {'value_string' | NONE}
SAVE DEFAULT PROPERTY property_name VALUE {'value_string' | NONE}
SAVE DEFAULT PROPAGATE PROPERTY {WHERE name {=|<|<=|>|>=|<>}'value' | NONE}
Usage
The SAVE PROPERTY statements set properties in the replica for a transaction that is saved for propagation to the master. The SAVE PROPERTY statements are applicable only in advanced replication configurations. They can only be issued on the replica databases. The property values can be read in the master database.
The SAVE PROPERTY statement assigns properties to the current active transaction.
The statements of the transaction in the master database can access these properties by calling the GET_PARAM() function. Properties are only available in the replica database that apply to the following command:
MESSAGE APPEND unique_message_name PROPAGATE TRANSACTIONS WHERE property > 'value_string'
When the transaction is executed in the master database, the saved properties are placed on the parameter bulletin board of the transaction. If the saved property already exists, the new value overwrites the previous one.
The SAVE DEFAULT PROPERTY statement defines default properties that are saved to all transactions of the current connection.
The SAVE DEFAULT PROPAGATE PROPERTY WHERE statement saves default transaction propagation criteria. This can be used for example to set the propagation priority of transactions created in the current connection.
The SAVE DEFAULT PROPAGATE PROPERTY WHERE statement can be used on connection level to append all MESSAGE unique_message_name APPEND PROPAGATE TRANSACTIONS statements to have the default WHERE statement. If the WHERE statement is entered also in the PROPAGATE statement, it will override the statement set with the DEFAULT PROPAGATE PROPERTY.
A property or a default property can be removed by re-saving the property with value string NONE.
Return values
Error code
Description
13086
Invalid data type in a parameter.
Result set
The SAVE PROPERTY statements do not return a result set.
Examples
SAVE PROPERTY conflict_rule VALUE 'override'
SAVE DEFAULT PROPERTY userid VALUE 'scott'
SAVE DEFAULT PROPERTY userid VALUE NONE
SAVE DEFAULT PROPAGATE PROPERTY WHERE priority > '2'
Related reference
See also
solidDB® SQL statements