solidDB Help : solidDB reference : SQL: Statements : SET : SET SYNC : SET SYNC PARAMETER
  
SET SYNC PARAMETER
Note Applies to only solidDB Advanced Replication configurations.
SET SYNC PARAMETER parameter‑name {'value‑as‑string' | NONE}
Access requirements
▪ In master: Valid master user
▪ In replica: SYS_SYNC_ADMIN_ROLE role
Usage
Use the SET SYNC PARAMETER statement in a master or replica database to define or remove a persistent catalog-level parameter from the parameter bulletin board. Each catalog has a different set of parameters.
If the parameter already exists, the new value overwrites the previous one.
If defined in a replica database, the parameter is not propagated to the master database.
For a list of predefined solidDB parameters that you can change by using the SET SYNC PARAMETER statement, see Advanced Replication: Bulletin board parameters.
Parameters, clauses, keywords, and variables
▪ NONE: Deletes an existing parameter.
Return values
For details on each error code, see Error codes.
 
Error code
Description
13086
Invalid data type in a parameter
See also, GET_PARAM and PUT_PARAM in Advanced Replication functions.
Examples
SET SYNC PARAMETER db_type 'REPLICA'
SET SYNC PARAMETER db_type NONE
Go up to
SET SYNC