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.
You have generated schema maps with the CREATE SCHEMAMAP statement. The necessary entries are therefore located in the MAPSCHEMANAMES system table.
<use_schema_map_command> ::= USE SCHEMAMAP <schema_map_name>
<schema_map_name> ::= <identifier>
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).
USE SCHEMAMAP hotel_to_mona
The current database user is to use the HOTEL_TO_MONA schema map.
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.