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.
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
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ar20000_ |