The Remove DPR Subscription Member (RMVDPRSUBM) command removes a member from the subscription control tables for a specified set. The command issues an error message if the requested entry is not found in the table.

You can use the DLTTGTTBL parameter to delete the target table associated with this subscription. You can use the RMVREG parameter to remove the registration to the target table if it was registered as a source table when the subscription was created.

This command supports the iSeries environment only, and not the other databases that support DataPropagator.

• Note: Do not precede an entry with an asterisk unless that entry is shown on the display itself or in the help information with an asterisk.

Error Messages for ADDDPRSUBM

*ESCAPE Messages

ASN2501

Not authorized to register table.

ASN3221

DLTTGTFILE(*YES) is not allowed with RMVCAPE(*NO).

ASN3239

Registration for target table cannot be removed.

ASN3240

Registration for target table cannot be removed.

ASN3242

Registration not found on data server for table .

ASN3243

Registration for target table cannot be removed.

ASN3244

Target table cannot be deleted because it is registered as a source table.

ASN3245

Target table in library could not be deleted.

ASN3246

Source table registration not changed because connection to failed.

ASN3247

Target table registration not removed because connection to failed.

ASN3252

Subscription not found.

ASN3256

Not authorized to Subscription Set table.

ASN3257

Not authorized to Subscription Member table.

ASN3258

Not authorized to Subscription Columns table.

ASN3263

Not authorized to Prune Control table.

ASN3270

Member does not exist.

ASN3272

Member cannot be removed.

ASN3292

Register table not found.

ASN3293

Pruning control table not found.

ASN4512

Set subscription table not found.

ASN4518

Subscription member table not found.

ASN4520

Subscription columns table not found.

Parameters

Keyword	Description	Choices	Notes
APYQUAL	Apply qualifier	Name	Required, Positional 1
SETNAME	Set name	Name	Required, Positional 2
TGTTBL	Target table	Qualified object name	Required, Positional 3
	Qualifier 1: Target table	Name
	Qualifier 2: Library	Name
CTLSVR	Control server	Name, *LOCAL	Optional
RMVREG	Remove DPR registration	*YES, *NO	Optional
DLTTGTTBL	Delete target table	*YES, *NO	Optional

Top

Apply qualifier (APYQUAL)

Specifies the apply qualifier. The apply qualifier is the name which is used to group the subscriptions that are to be run by the same Apply instance. The apply qualifier must already exist in the IBMSNAP_SUBS_SET table.

Set name (SETNAME)

Specifies the Set Name which identifies a group of target tables (subscription set members) that are processed by the Apply program as a group. The set name must already exist in the IBMSNAP_SUBS_SET table.

Target table (TGTTBL)

Specifies the target table member to remove from the subscription set.

library/target-table-name

The qualified name of the target table.

Control server (CTLSVR)

The relational database name where the Apply control tables exist. This is the relational database name for the control server.

*LOCAL

The Apply control tables are located on the local relational database.

rdb-name

The relational database name where the Apply control tables reside. You can use the Work with RDB Directory Entries (WRKRDBDIRE) command on the data server to find this name. If the Apply control tables are on the system where the ADDDPRSUB command is being executed, rdb-name is the relational database name that has a remote location of *LOCAL associated with it.

Remove DPR registration (RMVREG)

Specifies whether to remove the target table registration.

*NO

The target table registration is not removed.

*YES

The target table registration is removed. If the target table is registered as a source table and the Pruning Control table associated with the registration is empty, an entry will be removed from the ASN/IBMSNAP_REGISTER table.

Delete target table (DLTTGTTBL)

Specifies whether or not the target table is to be deleted after the subscription is removed.

*NO

The target table should not be deleted.

*YES

The target table should be deleted.

Examples

None

Error messages

*ESCAPE Messages

ASN2501

Not authorized to register table.

ASN3221

DLTTGTFILE(*YES) is not allowed with RMVCAPE(*NO).

ASN3239

Registration for target table cannot be removed.

ASN3240

Registration for target table cannot be removed.

ASN3242

Registration not found on data server for table .

ASN3243

Registration for target table cannot be removed.

ASN3244

Target table cannot be deleted because it is registered as a source table.

ASN3245

Target table in library could not be deleted.

ASN3246

Source table registration not changed because connection to failed.

ASN3247

Target table registration not removed because connection to failed.

ASN3252

Subscription not found.

ASN3256

Not authorized to Subscription Set table.

ASN3257

Not authorized to Subscription Member table.

ASN3258

Not authorized to Subscription Columns table.

ASN3263

Not authorized to Prune Control table.

ASN3270

Member does not exist.

ASN3272

Member cannot be removed.

ASN3292

Register table not found.

ASN3293

Pruning control table not found.

ASN4512

Set subscription table not found.

ASN4518

Subscription member table not found.

ASN4520

Subscription columns table not found.