Creating a Replication Server Function String

A Replication Server function string is used to map a database command to a data server API. For the rs_select and rs_select_with_lock functions only, the string contains an input template used to match function strings with the database command. For all functions, the string also contains an output template, used to format the database command for the destination data server.

1. Open Enterprise Explorer, and connect to your Replication Server.
2. Expand the view for your Replication Server connection profile, right-click a primary database for which to create the function string, and choose New Artifact from the context menu.
3. From the wizard selection screen, select Function String, and click Next. You can also start this wizard by right-clicking the Function Strings folder for an existing function-string class and choosing New Function String.
4. Specify function string settings.

   Field	Description
   General settings	Specify general settings for the function string: Function name: Select a corresponding Replication Server function from the menu drop-down. Replication definition: Select a corresponding replication definition from the menu drop-down. Function string name: Enter a name for the function string.
   Function string class	Select a function-string class from the menu drop-down.
   With overwrite	Specify whether to overwrite any existing function strings of the same name you specified.

   Note: You can view the commands for creating a function string in the Preview field in this and subsequent steps.
5. Click Next, and select an output setting.

   Field	Example
   No output	Select this option if your function string produces no output.
   Language output template	Specify the output template Replication Server should use to map the function to language commands on the destination database. For more information on output templates, see the Replication Server Administration Guide .
   RPC	Select this option to map your function string to a remote procedure call (RPC). If you select this option, you must specify the name of the RPC and describe its parameters in the grid. Enter a name for the remote procedure in the text field. Use Add... and Edit... to add or edit a remote procedure parameter setting for the specified RPC. These start the Remote procedure parameter setting wizard, in which you must specify the following: Parameter name: Enter the name of the RPC parameter. Constant: Enter a constant value if this parameter is a constant. Variable name and modifier: If this is a variable, specify a name and modifier from the menu drop-downs. Click OK when you are done. Use Remove and Remove All to remove one or all specified RPC parameters.
   Write text	This output template can only be used in rs_writetext function strings. For more information, see the Replication Server Administration Guide .
   None	This option applies only to rs_writetext function strings. For more information, see the Replication Server Administration Guide .

6. Specify an input template for this function string in the Input Template field.

   For more information on input templates, see the Replication Server Administration Guide.

7. Click Finish to create the function string.

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.