Mapping specification language file

The mapping specification language (.msl) file is an XML file that describes the mapping between a source and target element.
The .msl file is displayed graphically in the mapping editor. Do not modify the .msl file directly. Instead, modify your model only with the mapping editor. You create an SQL script from the .msl file that you can then deploy to your server or another server.

Example of a script that is generated from a mapping model that maps department numbers with different data types

The following example shows a mapping model that maps the DEPTNUMB column from the ORG table in Org.dbm, and DEPTNO from the DEPARTMENT table in Department1.dbm:
Figure 1. Transform to the target data typeThe graphic displays a simple mapping model that shows a transformation.

The following example shows the generated script from the mapping model that is displayed in Figure 1

SELECT CHR(S0.DEPTNUMB) AS  DEPTNO,
        CAST('' AS  VARCHAR) AS  DEPTNAME,
        CAST(NULL AS  CHAR) AS  MGRNO,
        CAST('' AS  CHAR) AS  ADMRDEPT,
        CAST(NULL AS  CHAR) AS  LOCATION
FROM  SAMP.ORG S0;
Related tasks
Creating a mapping model
Generating scripts that you can deploy

Feedback