This command is available only for Oracle and Microsoft
SQL Server.
Creates a replication definition at Replication Server for a marked table and procedure, or for all marked tables and procedures.
Replication Agent 15.1 is pre-configured to match replication
definition datatypes available in Replication Server 15.0 and later.
If replication definitions are to be generated against an earlier
version of Replication Server, this configuration needs to be changed.
Contact Sybase Technical Support for assistance in making this adjustment.
rs_create_repdef {all | name}
A replication definition is created for all tables and procedures that are marked for replication.
A replication definition is created for the table or procedure specified by name.
This command always assumes that a database Replication
definition exists for the primary database.
This command always assumes that a database replication definition exists for the primary database. All replication definitions created by this command include the send standby clause, which means the replication definition will only be used by Replication Server if there is already a database level replication definition. The replication definition created by rs_create_repdef can not be individually subscribed to. If you do not wish to have a database level replication definition, you must use a different tool, or create replication definitions manually, and not use rs_create_repdef.
Replication definitions created by rs_create_repdef will always define the datatypes using available UserDefinedDatatypes that are installed in Replication Server. This means that customers using rs_create_repdef should not set Replication Agent configuration property pdb_convert_datetime to true, as this will convert date and timestamp datatypes to Sybase format, instead of UDD format.
Replication Agent configuration property pdb_auto_create_repdefs has the same result as executing command rs_create_repdef.
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 only for that table or procedure.
For each table or procedure for which a replication definition 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 will be returned.
The character case of the object names in the replication definition will be set according to the ltl_character_case setting.
The following applies to replication definition table and procedure names:
All non-alphanumeric characters and spaces are removed and are not part of the table or procedure name.
Underscores are kept as part of the name even though they are non-alphanumeric characters.
Periods are replaced with underscores.
Replication definition names for tables always begin with the prefix “ra$,” followed by a unique alphanumeric identifier (maximum of 8 characters), and ending with a table or object name. For example, for a replicate name of “My Table,” the resulting repdef name is “ra$0x7952_mytable.” For an especially long replicate name of “mytable89012345678901234567890” (30 characters), the resulting repdef name is “ra$0x7952_mytable8901234567890” (30 characters maximum).
