ADDTBL - Add Tables

Use this command to add source tables to the catalog for possible replication.

You can add individual tables, generic groups of tables, or all tables within a library with a single execution of this command. After adding the tables you want to replicate, you need to select the table for replication using the SLTTGTTBL command. You can remove added tables by using the RMVTBL command.

Applies To—Source

Parameters

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

Source table name (TABLE)

Specifies the name of the source table to add to the Source Tables area in Management Console.

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

ADDTBL TABLE(PRODLIB/CUSTOMER)

Adds the source table named CUSTOMER that resides in library PRODLIB to the catalog.

ADDTBL TABLE(DTUTOR/*ALL)

Adds all source tables that reside in library DTUTOR to the catalog.