Defining the schema name

By default in mappings, database table names are identified by the broker default schema and are in the format: Database.table_name. However, if you define a schema for your application, and define tables within the schema, the table names must be prefixed with the schema name to produce the following format: Database.schema_name.table_name. The following steps show you how to define the schema name globally.

  1. Open the Preferences dialog by clicking Window > Preferences. Click ESQL and Mapping , then Code Generation.
  2. Select one of the three options:
    1. Use default runtime schema for this data source produces the format: Database.table_name
    2. Use schema name in table definition produces the format: Database.schema_name.table_name where schema name is obtained from the database table .xmi file
    3. Use name specified produces the format: Database.user_specified_schema_name.table_name.
  3. Click OK to save your changes. The options chosen affect all tables in all mapping files, unless specified differently for an individual table.

You can also define the schema name for an individual table in a mapping file as described in Adding a database mapping input and Adding a database mapping output. Defining a schema for an individual table overrides the definition in the Preferences dialog.

Related concepts
Mappings
Mapping types
Message mapping
Related tasks
Adding a database mapping input
Adding a database mapping output
Mapping and ESQL
Related reference
Mappings