eTL Environment Properties (Configuring Java CAPS Environment Components for Database Adapters)

Configuring Java CAPS Environment Components for Database Adapters

eTL Environment Properties

This section contains all the configuration properties needed for eTL collaborations.

Alternate ID Properties

This section contains all the configuration properties that allow the user to override database catalogs and/or schema names used in the sql statements generated by eTL collaborations. The Alternate ID section contains the top-level parameters displayed in the following table. The configuration properties specified in this section will not affect the functionality of DB2 Adapter.

Table 13 eTL Environment - Alternate ID Settings


Name	Description	Required Value
OverwriteCatalog Name	Indicates whether or not to overwrite the database catalog name in the sql statements generated by eTL collaboration.	A True or False value. If you select “True”, the content of the “CatalogNameMap” property will be used. If “False” is selected, the catalog name will be ovewritten. The default is True.
CatalogNameMap	Specifies the key-value pair(s) for catalog name overwrites. The correct format is: <oldCatalogName1>=<newCatlogName1>;<oldCatalogName2>=<newCatalogName2>;...	A semi-colon separated list that contains valid name overwrites.
OverwriteSchema Name	Indicates whether or not to overwrite the database schema name in the sql statements generated by eTL collaboration.	A True or False value. If you select “True”, the content of next configuration property “SchemaNameMap” will be used. If “False” is selected, the schema name will be ovewritten. The default is True.
SchemaNameMap	Specifies the key-value pair(s) for schema name overwrites. The correct format is: <oldSchemaName1>=<newSchemaName1>;<oldSchemaName2>=<newSchemaName2>;...	A semi-colon separated list that contains valid name overwrites.