Editing a Replication Server Function

Edit a Replication Server function using SQL Scrapbook.

  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 in which to edit a function, and expand the folder containing the replication defintion.
  3. Expand the Functions folder below the replication definition, right-click the function you want to edit, and select Edit from the context menu.

    The SQL for this function appears in SQL Scrapbook.

  4. Edit the function.
    Note: You cannot edit a system object. If this replication function is a system object, you can view its contents in SQL Scrapbook but cannot save the changes.
  5. Right-click in content window of SQL Scrapbook, and choose the appropriate context-menu option for saving.
    Men option Description
    Save as Template Select this option to save the SQL as a template that can be reinserted in future editor sessions. In the New Template wizard:
    • Specify a name and context for the template.
    • Optionally specify a template description.
    • In the Pattern field, manually edit the template definition. Click Insert Variable to generate a list of variables, and select one to insert at the cursor position.
    When you are finished, click OK to save the new template.
    Save As Specify project information and a file name in the Save As dialog.
    Save to Server Select this option to save the artifact to the Replication Server on which it currently resides.
Related concepts
Replication Server Functions
Related tasks
Creating a Replication Server Function
Dropping a Replication Server Function

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.