ENDDTARSH - End data refresh

Use this command to specify how you want CDC Replication to end a refresh operation to the specified target table.

By default, CDC Replication ends a refresh operation to the target table in a controlled manner.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword	Description	Choices	Notes
TARGET	Subscription name	`Name`, generic, ALL	Required
ENDTYP	End type	CNTRLD, IMMED	Optional

Specifies the name of the subscription.

This is a required parameter.

Name: Specify the name of a subscription. This must be the same name defined in Management Console.
generic*: Generic names may be used for subscriptions, by adding an asterisk (*) after one or more characters that are common to the group of subscriptions names. For example, 'abc*' specifies all subscriptions starting with the characters 'abc'.
*ALL: Specifies all subscriptions.

Specifies how you want to end replication. Specifies how you want to end replication.

*CNTRLD: Specifies a controlled end to a refresh.; This is the default setting.
*IMMED: CDC Replication ends a refresh immediately.

None

ENDDTARSH TARGET(SUB1)

CDC Replication ends the refresh on subscription SUB1 end in a controlled manner.

ENDDTARSH
TARGET(SUB1) ENDTYP(*IMMED)

CDC Replication ends the refresh on subscription SUB1 immediately.

ENDDTARSH
TARGET(*ALL) ENDTYP(*IMMED)

CDC Replication ends the refresh on all subscriptions immediately.