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
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*;