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
| 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.