Creates a replication definition at Replication Server® for a designated marked table or procedure, or for all marked tables and procedures.
rs_create_repdef [all | TABLE_NAME]
all A replication definition is created for all tables and procedures that are marked for replication.
TABLE_NAME A replication definition is created for that table or procedure.
When rs_create_repdef is invoked and the parameter all or ALL is entered, a replication definition is created for all tables or procedures that are marked for replication.
When rs_create_repdef is invoked and the name of a table or procedure that is marked for replication is entered, a replication definition is created for that table or procedure.
For each table or procedure for which a replication definition of create is attempted, a result set is returned. The result set contains the replication definition name and status of the create. If the replication definition was created, the status will be created. If an error occurred, an error message from Replication Server or Replication Agent will be returned.
The ltl_character_case configuration parameter setting determines the character case of the object names in the replication definition.
Replication definition names for tables always begin with the prefix ra$, followed by an alphanumeric value and the replicate table name. (See the following examples.) All non-alphanumeric characters except the underscore and period are removed from the replicate table name. The period (".") is converted to an underscore, and the resulting name is truncated, if necessary, to 24 characters (repdef names are limited to 30 characters.)
The following table identifies examples of replicate names and their resultant repdef names.
Table name |
Replication definition name |
|---|---|
order$req |
ra$0x794a_orderreq |
orderreq |
ra$0x7952_orderreq |
my.orderreq |
ra$0xa154my_orderreq |
The replication definition name for a procedure is the same name as the procedure.
