If you want to set up your own mappings, indicate that you want
to edit the To template by selecting the Edit template mapping option
on the To panel for the relevant FM/Db2 function. If you select
this option, FM/Db2 displays the Template Mapping panel (see Template Mapping panel). Figure 1. Template Mapping panel
Process Options Utilities Help
────────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) Template Mapping
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
Note that, in Template Mapping panel, there is no From columns
against the To columns RID and TSTAMP. This shows that, for
these two columns in the To template, there is no corresponding
column in the From template. When the table is copied,
FM/Db2 creates new values in RID and TSTAMP.