Dematerializing 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.

See “Function-string classes” on page 21 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 32 in the Replication Server Administration Guide Volume 2.