Creating a Replication Server Function String

Create a Replication Server function string, which maps 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. Expand the tree for the Replication Server connection profile, right-click a primary database for which to create the replication definition, and select New Artifact.
2. Select Function String and click Next.
3. Specify function string settings.

   Field	Description
   General Settings	Select a Function Name and Replication Definition. Enter a Function String Name.
   Function String Class	Select a function-string class.
   With Overwrite	Specify whether to overwrite any existing function strings of the same name you specified.

4. 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 uses to map the function to language commands on the destination database.
   RPC	Map your function string to a remote procedure call (RPC). If you select this option, specify the name of the RPC and describe its parameters in the grid. Enter a name for the RPC. Use Add... and Edit... to add or edit a remote procedure parameter settings. 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. Click OK when you are done. Use Remove and Remove All to remove one or all specified RPC parameters.
   Write Text	Use this output template for rs_writetext function strings only.
   None	Use this output template forrs_writetext function strings only.

5. Specify an Input Template.
6. Click Finish to create the function string.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com