;
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
⋮
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)
15 RID CH(4) | 6 PHONENO 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
Process Options Utilities Help
────────────────────────────────────────────────────────────────────────────────
FM/Db2 (DFG2) From Column Mapping
To Db2 object . . : DSN8810.EEMP
From Db2 object . : DSN8810.EMP
To column . . . . : #13 BONUS
From column . . . :
Sel Cl# From Column Data Type(length)
**** Top of data ****
___ D Delete "From column"
___ 1 EMPNO CHARACTER(6)
___ 2 FIRSTNME VARCHAR(12)
___ 3 MIDINIT CHARACTER(1)
___ 4 LASTNAME VARCHAR(15)
___ 5 WORKDEPT CHARACTER(3)
___ 6 PHONENO CHARACTER(4)
7 HIREDATE DATE
___ 8 JOB CHARACTER(8)
___ 9 EDLEVEL SMALLINT
___ 10 SEX CHARACTER(1)
11 BIRTHDATE DATE
___ 12 SALARY DECIMAL(9,2)
___ 13 BONUS DECIMAL(9,2)
___ 14 COMM DECIMAL(9,2)
**** End of data ****
Command ===> _____________________________________________________ Scroll PAGE
F1=Help F2=Split F3=Exit F4=CRetriev F7=Up F8=Down
F9=Swap F12=Cancel
Exit function key (F3) を押します。
To (宛先) 列 BONUS がどの From (元) 列にもマップされていないことを示す「Template Mapping (テンプレート・マッピング)」パネルが表示されます。図 4. 「宛先」列「BONUS」がどの「元」列にもマップされていないことを示す「Template Mapping (テンプレート・マッピング)」パネル
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
⋮
12 SALARY DEC(9,2) | 12 SALARY DEC(9,2)
13 BONUS DEC(9,2) |
14 COMM DEC(9,2) | 14 COMM DEC(9,2)
15 RID CH(4) | 6 PHONENO 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