PowerExchange 10.5 includes the following new parameters for the DTLUCBRG utility:
EXCLUDE_COL=
column_name
A column name or name pattern for excluding columns from the capture registrations you are creating for source tables. To define a name pattern that can identify multiple columns, include the asterisk (*) wildcard anywhere within the name, for example, tx*custid. This value is matched against column names in a case-insensitive manner.
You can repeat this parameter multiple times to specify multiple name values. If you specify the EXCLUDE_COL parameter, do not also define the INCLUDE_COL parameter. These parameters are mutually exclusive.
EXCLUDE_TYPE=
data_type
A column data type to use for excluding columns from the capture registrations you are creating for source tables. All columns that have the specified data type will be excluded from the registrations. You might want to use this parameter to exclude data types that PowerExchange does not support or to satisfy certain site-specific requirements.
This value is matched against column date types in a case-insensitive manner. For example, the values
clob
and
CLOB
would have the same result. You can repeat this parameter multiple times to specify multiple data types.
INCLUDE_COL=
column_name
A column name or name pattern for including columns in the capture registrations you are creating for source tables. To define a name pattern that can identify multiple columns, include the asterisk (*) wildcard anywhere within the name, for example, tx*custid. This value is matched against column names in a case-insensitive manner.
You can repeat this parameter multiple times to specify multiple name values. If you specify the INCLUDE_COL parameter, do not also define the EXCLUDE_COL parameter. These parameters are mutually exclusive.
For more information, see the "DTLUCBRG - Batch Registration Utility" chapter in the