Before you use any mappings that you create, ensure that any databases that you have defined are registered with ODBC correctly on your computer.
There are two ways to add a database mapping output (target) from the Resource Navigator view, depending on whether you are adding the database to the workspace for the first time or if the database has been imported previously and is already in the workspace.
If you cannot import the database definition, ask your database administrator to export the schema files for you to use.
You can also import database schema files using the Data Perspective.
Database.table_nameHowever, if you define a schema for your application and define tables within the schema, you must prefix the table names with the schema name to produce the following format:
Database.schema_name.table_nameTo do this:
Defining the schema name for an individual table, as described above, overrides the global definition in the Preferences dialog (see Defining the schema name).
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ar03020_ |