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.
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 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: specifies the default iSeries library that the adapter will access.
  • adb.as400.library: specifies the name of the runtime iSeries library that the adapter will access.