Dematerialization and Purging Rows

Use the with purge clause when you want to delete rows replicated by the subscriptions you are dropping.

Use the incrementally option to delete rows in 1000-row increments. The maintenance user for the replicate database must have select permission on the table to use this option.

Dematerializing a subscription and purging rows from the replicate table uses function strings for the rs_select or rs_select_with_lock system functions. You may be required to create a function string for these system functions.

If the connection for the replicate database uses a function-string class with default-generated function strings or a function-string class inherited from such a class, Replication Server generates a corresponding default function string for the rs_select_with_lock or rs_select functions.
If the connection uses any other function-string class, you must create the function string, with an input template that matches the subscription’s where clause. Use the create function string command.

See Replication Server Administration Guide Volume 2 > Customize Database Operations > Function-string Classes for details.

If you are using a function-string class in which you can customize function strings, you can replace an existing default or custom function string with one that performs a select operation that your application requires, using the alter function string command.

For more information on creating or altering rs_select and rs_select_with_lock function strings, see Replication Server Administration Guide Volume 2 > Customize Database Operations > Manage Function Strings.