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