TABLEEXCLUDE

Valid for

Extract

Description

Use TABLEEXCLUDE with the TABLE or MAP parameter to explicitly exclude tables from being included in a wildcard specification. Must follow a TABLE or MAP statement that uses wildcards.

Syntax

TABLEEXCLUDE exclude_specification

exclude_specification: The name or wildcard specification of the table to exclude.

Example

In the following example, TABLE retrieves all tables from $DATA.MASTER, except those tables containing the letter X, and the table named BIGTAB. Those tables not excluded by the TABLEEXCLUDE parameter are output to the aa trail. All tables containing the letter X are output to bb trail.

RMTTRAIL /ggdat/aa
TABLE $DATA.MASTER.*;
TABLEEXCLUDE $DATA.MASTER.*X*;
TABLEEXCLUDE $DATA.MASTER.BIGTAB;

RMTTRAIL /ggdat/bb
TABLE $DATA.MASTER.*X*;