Subscription prefix and suffix |
Specify a prefix or suffix for the subscription or subscriptions you are creating. These are optional.
|
Subscriptions |
Select subscriptions in the grid.
-
RepDef Name: This is the name of the replication definition for this subscription. This field is not modifiable.
- Subscription: Specify the name by which you want the subscription to be known. To modify a value, click in the field, and type the desired subscription name.
Materialization: Specify materialization preferences for replicate tables. As a default, this field specifies Without materialization. To modify this value, click in the field, and select another option from the menu drop-down. Alternate options are Without holdlock, Incrementally, and Atomic materialization.
-
Grant Permission: Select the corresponding check-box to grant permission for this subscription.
-
Truncate Table: Specify whether or not the
truncate table
command should be enabled for this subscription. For more information on this command, see the Replication Server Administration Guide.
Use
Select All and
Deselect All to select or deselect all subscriptions. Use
Invert to invert selections.
|
Where clause |
Set criteria for column or parameter values to be replicated in this subscription:
- Name: Click in this field, and select a column or parameter from the drop-down menu.
- Operator:
Click in this field, and select a boolean operator from the drop-down menu.
- Value:
Enter a value for the where-clause condition.
Use Remove or Remove All to respectively remove one or all clauses.
|