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 “Function-string classes” on page 22 in the Replication Server Administration Guide Volume 2 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 “Managing function strings” on page 33 in the Replication Server Administration Guide Volume 2.
