This section presents the formatting rules for RCL commands, which are similar to Transact-SQL® commands.
You can break a line anywhere except in the middle of a keyword or identifier. You can continue a character string on the next line by typing a backslash (\) at the end of the line.
Extra space characters on a line are ignored, except after a backslash. Do not enter any spaces after a backslash.
You can enter more than one command in a batch, unless otherwise noted.
RCL commands are not transactional. Replication Server executes each command in a batch without regard for the completion status of other commands in the batch. Syntax errors in a command prevent Replication Server from parsing subsequent commands in a batch.
Identifiers are names you give to database or replication objects. They include object names, column names, variable names, and parameter names.
Identifiers can be 1–30 bytes long (equivalent to 1–30 single-byte characters). The first character must be a letter or the @ or _ character.
After the first character, identifiers can include letters, digits, and the #, $, or _ character. You cannot embed spaces in identifiers, unless the identifier appears in quotation marks.
Replication Server function parameters are the only identifiers that can begin with the @ character. Function parameter names can include 30 characters after the @ character.
Keywords in RCL commands are not case-sensitive. You can enter them with any combination of uppercase or lowercase letters.
Identifiers and character data may be case-sensitive, depending on the sort order that is in effect.
If you are using a case-sensitive sort order, such as “binary,” you must enter identifiers and character data with the correct combination of uppercase and lowercase letters.
If you are using a sort order that is not case-sensitive, such as “nocase,” you can enter identifiers and character data with any combination of uppercase or lowercase letters.
Parameters in function strings have the same rules as identifiers, except:
They are enclosed in question marks (?), allowing Replication Server to locate them in the function string. Use two consecutive question marks (??) to represent a literal question mark in a function string.
The exclamation point (!) introduces a parameter modifier that indicates the source of the data that will be substituted for a parameter at runtime. For a complete list of modifiers, see create function string.
