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 theTo
template. - Column name (TO)
- The
To
column name. The name of the column in theTo
template. - Datatype (TO)
- The
To
data type. The data type and, optionally, the length of the column in theTo
template. - NI (TO)
- The
To
Null Indicator. The null indicator for the column in theTo
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 theFrom
template. - Column name (FROM)
- The
From
column name. The name of the column in theFrom
template. - Datatype (FROM)
- The
From
data type. The data type and, optionally, the length of the column in theFrom
template. - NI (FROM)
- The
From
Null Indicator. The null indicator for the column in theFrom
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 Sin Cmd field |