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 type
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;