RMVTBL - Remove tables

Use this command to remove source tables that were added to a catalog for possible replication.

You can remove individual tables, generic groups of tables or all tables in a library with a single execution of this command. Only source tables that have been added are considered when you issue this command.

Before using this command to remove the source tables, you should de-assign target tables and deselect source tables.

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`
ENDJRN	Journaling format	Y, N	Optional

Source table name (TABLE)

Specifies the name of the source table that is removed from the catalog.

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.

Journaling format (ENDJRN)

Indicates whether or not journaling to the default CDC Replication journal should stop or continue for the specified table.

This parameter does not have any effect if a user-defined journal, as opposed to the default journal, is being used.

Y: Specifies that journaling stop for the specified table.; This is the default setting.
N: Specifies that journaling continue for the specified table.

Result

Relevant messages are sent to the job log.

Examples

RMVTBL TABLE(DTUTOR/SALES)

Source table SALES in library DTUTOR is removed from the catalog.

Journaling is stopped for the SALES table.

RMVTBL TABLE(DTUTOR/*ALL)
ENDJRN(Y)

All added source tables in library DTUTOR are removed from the catalog.

Journaling is stopped for the removed source tables in library DTUTOR.

RMVTBL TABLE(DTUTOR/CUSTOMER)
ENDJRN(N)

Source table CUSTOMER in library DTUTOR is removed from the catalog.

Journaling continues for the CUSTOMER table.