Template Mapping panel

You use the Template Mapping panel to specify the columns in the source (the From columns) you want transferred to the columns in the target (the To columns) when you are moving (copying) data.

Panel and field definitions

 Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)                 Template Mapping                    Line 1 of 16

 To          FMNUSER.EEMP
 From        FMNUSER.EMP

 Cmd CL# To Column name  Datatype  NI   CL# From Column name        Datatype  NI
         ****  Top of data  ****
       1 EMPNO           CH(6)     NN |   1 EMPNO                   CH(6)     NN
       2 FIRSTNME        VC(12)    NN |   2 FIRSTNME                VC(12)    NN
       3 MIDINIT         CH(1)     NN |   3 MIDINIT                 CH(1)     NN
       4 LASTNAME        VC(15)    NN |   4 LASTNAME                VC(15)    NN
       5 WORKDEPT        CH(3)        |   5 WORKDEPT                CH(3)
       6 PHONENO         CH(4)        |   6 PHONENO                 CH(4)
       7 HIREDATE        DATE         |   7 HIREDATE                DATE
       8 JOB             CH(8)        |   8 JOB                     CH(8)
       9 EDLEVEL         SMINT        |   9 EDLEVEL                 SMINT
      10 SEX             CH(1)        |  10 SEX                     CH(1)
      11 BIRTHDATE       DATE         |  11 BIRTHDATE               DATE
      12 SALARY          DEC(9,2)     |  12 SALARY                  DEC(9,2)
      13 BONUS           DEC(9,2)     |  13 BONUS                   DEC(9,2)
      14 COMM            DEC(9,2)     |  14 COMM                    DEC(9,2)
 S    15 RID             CH(4)        |
      16 TSTAMP          TIMESTAMP    |
         ****  End of data  ****
 Command ===>                                                       Scroll PAGE
  F1=Help      F2=Split     F3=Exit      F4=CRetriev  F5=RFind     F6=RunTemp
  F7=Up        F8=Down      F9=Swap     F12=Cancel
TO
The To Db2® object. The Db2® object to which data will be imported.
FROM
The From data set. The name of the import data set.
Cmd
Prefix command area, used to enter a template editor prefix command. S or E to edit the column mapping.
Cl# (TO)
The To column number. The number of the column in the To template.
Column name (TO)
The To column name. The name of the column in the To template.
Datatype (TO)
The To data type. The data type and, optionally, the length of the column in the To template.
NI (TO)
The To Null Indicator. The null indicator for the column in the To template:
(blank)
The column allows null values
NN
The column does not allow null values.
Cl# (FROM)
The From column number. The number of the column in the From template.
Column name (FROM)
The From column name. The name of the column in the From template.
Datatype (FROM)
The From data type. The data type and, optionally, the length of the column in the From template.
NI (FROM)
The From Null Indicator. The null indicator for the column in the From template:
(blank)
The column allows null values
NN
The column does not allow null values.

Parent panels

Child panels

To display this panel… Use/do this
From Column Mapping panel Enter S in Cmd field

Related tasks