EXCLUDEWILDCARDOBJECTSONLY
Valid For
GLOBALS
Description
Use the EXCLUDEWILDCARDOBJECTSONLY
parameter to force the inclusion of non-wildcarded source objects specified in TABLE
or MAP
parameters when an exclusion parameter contains a wildcard that otherwise would exclude that object. Exclusion parameters are CATALOGEXCLUDE
, SCHEMAEXCLUDE
, MAPEXCLUDE
, and TABLEEXCLUDE
.
The exclusion parameters get evaluated and satisfied before the TABLE
or MAP
statements. Without EXCLUDEWILDCARDOBJECTSONLY
, it would be possible for an object in a TABLE
or MAP
statement to be wrongly excluded because it satisfies the wildcard in the exclude specification. For EXCLUDEWILDCARDOBJECTSONLY
to work on an object, that object must be explicitly named without using wildcards in any of the name components.
Default
None
Syntax
EXCLUDEWILDCARDOBJECTSONLY
Example
In this example, schema1.src_table1
is included in processing because the TABLEEXCLUDE
parameter is wildcarded and the TABLE
specification is not wildcarded. Without EXCLUDEWILDCARDOBJECTSONLY
, schema1.src_table1
would be excluded because of the wildcard specification in TABLEEXCLUDE
.
TABLEEXCLUDE schema1.src_table*; TABLE schema1.src_table1;