DSLTGTTBL - Deselect source tables

Use this command to deselect a source table from a subscription.

After deselecting a source table, you cannot replicate this source table to the target. You can deselect individual tables, generic groups of tables or all tables in a library from a subscription with a single execution of this command. Only tables that have already been selected for replication are affected by this command.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword Description Choices Notes
TARGET Subscription name Name Required
TABLE Source table name Qualified object name Required
Qualifier 1: Source table name Name, generic*, *ALL
Qualifier 2: Library Name

Subscription name (TARGET)

The name of the subscription, as defined in Management Console, to which the source table is selected.

This is a required parameter.

Name
Specify the name of a subscription. This must be the same name defined in Management Console.

Source table name (TABLE)

Specifies the name of the source table.

This is a required parameter.

Qualifier 1: Source table name
Name
Specifies the name of a table
generic*
Generic names may be used for tables, by adding an asterisk (*) after one or more characters that are common to the group of table names. For example, 'abc*' specifies all tables starting with the characters 'abc'.
*ALL
Specifies all tables.
Qualifier 2: Library
Name
Specifies the library where the table resides.

Result

Relevant messages are produced to the job log.

Examples

DSLTGTTBL TARGET(SUB1) TABLE(DTUTOR/*ALL)

All source tables in library DTUTOR selected to subscription SUB1 are deselected.

DSLTGTTBL TARGET(SUB1) TABLE(DTUTOR/CUSTOMER)

Source table CUSTOMER in library DTUTOR selected to subscription SUB1 is deselected.