solidDB Help : solidDB reference : SQL: System stored procedures : Miscellaneous stored procedures : SYS_REPLICATION_STATE_WAIT
  
SYS_REPLICATION_STATE_WAIT
The SYS_REPLICATION_STATE_WAIT procedure waits for events that report C Replicator (CREP) replicator status changes, see C Replicator.
The procedure takes no input parameters.
Example:
CALL SYS_REPLICATION_STATE_WAIT ()
The procedure is executed in the CREP target database. Whenever the CREP replicator status changes, the procedure call returns the values that are described in the following table:
 
Column name
Data type
Description
NAME
WVARCHAR
Subscription name
STATE
INTEGER
Replication status:
0: INIT
1: STARTING
2: CATCHUP
3: ACTIVE
4: LOAD
5: ERROR
6: STOPPED
Go up to
Miscellaneous stored procedures