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: This property specifies the design-time database object schema.
adb.runtime.schema: This property 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 will replace the design-time schema with this runtime schema. Otherwise, no action will be taken.
- If the adb.orignalSchema property is not specified, the adapter will append 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: This property 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.

Note: These configurations do not apply to the referred object in the Publish by Reference mode. You have to specify the runtime schema for the referred object during the design time, or in the ADB_REF_OBJECT column entry in the publishing table.

For the IBM iSeries (AS400) database, you can use the following TRA properties:

adb.as400.defaultLibrary: This property specifies the default iSeries library that the adapter will access.
adb.as400.library: This property specifies the name of the runtime iSeries library that the adapter will access.