Runtime Schema
In the case where the schema names of the table objects are different between the development and production environments, you can use TRA properties to specify schema configurations.
For all database environments other than IBM UDB iSeries (AS400), you can use the following TRA properties:
- adb.originalSchema: specifies the design-time database object schema.
- adb.runtime.schema: specifies the runtime table objects schema. Note the following conditions:
- If the adb.originalSchema property is specified, the adapter compares the adb.originalSchema property with the prefix of the table objects. If they are the same, the adapter replaces the design-time schema with this runtime schema. Otherwise, no action is taken.
- If the adb.orignalSchema property is not specified, the adapter appends this runtime schema to all the table objects that do not have any schema specified at design time.
- If the name of the adb.runtime.schema property contains a capital letter, the name must be with the double quote. For example: adb.runtime.schema="Test"
- adb.runtime.publisherSchema: specifies the runtime publishing table schema. The setting of this property overrides the setting of the adb.runtime.schema property. You can use the adb.runtime.publisherSchema property if you have a different schema for the publishing table than the other table objects, such as the source table.
Copyright © Cloud Software Group, Inc. All rights reserved.