USE SCHEMAMAP Command 

You can use the Loader’s USE SCHEMAMAP command for starting a database session to specify which schema map the current user is to use.

Prerequisites

You have generated schema maps with the CREATE SCHEMAMAP statement. The necessary entries are therefore located in the MAPSCHEMANAMES system table.

See also:

CREATE/DROP SCHEMAMAP Statement

MAPSCHEMANAMES

Syntax

<use_schema_map_command> ::= USE SCHEMAMAP <schema_map_name>

<schema_map_name>        ::= <identifier>

<schema_map_name>

Name of the schema map that the database user is to use If the name of the schema map is identical to a keyword or if the upper- and lowercase notation is relevant, the name must be placed in double quotation marks. See the SQL Reference Manual, Identifier (identifier).

Examples

USE SCHEMAMAP hotel_to_mona

The current database user is to use the HOTEL_TO_MONA schema map.

Explanation

With the USE SCHEMAMAP command, you can specify which schema map the current database user is to use. This setting for the Loader session is valid as long as no other schema map is specified by a USE SCHEMAMAP command or an IMPORT SCHEMA command.

See also:

Creating a Database Session: Commands

IMPORT SCHEMA Command