To set up or change the mapping for a column, enter S in
the Cmd field against the column name. The From Column Mapping
panel is displayed.
In From Column Mapping panel, the information at
the top of the panel shows you the current mapping. In the figure,
the To column is RID. There is currently no From column shown
because there is no column in the From template with the same
name.
To change the From column, enter S against
the new From column. The information at the top of the panel
changes immediately to reflect the new mapping. For example, if you
enter S against column #6 (PHONENO), the information
at the top of the panel changes:
;
FM/Db2 (DFG2) From Column Mapping
To Db2 object . . : DSN8810.EEMP
From Db2 object . : DSN8810.EMP
To column . . . . : #15 RID
From column . . . : #6 PHONENO
and the Template Mapping
panel also changes to show that PHONENO is mapped to RID:
;
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
There is now an entry in the From column against RID.
To remove the current mapping for a To column, enter S against Delete From
column on the From Column Mapping panel for that column. For
example, the Template Mapping panel shown in Template Mapping panel shows that the To column
BONUS is mapped to the From column BONUS. To remove the mapping
for BONUS (so that it is not mapped to any From column):
On the Template Mapping panel shown in Template Mapping panel, enter S in the Cmd field
against column #13 (BONUS).
The From column mapping information (fourth line on the
From Column Mapping panel) for BONUS is displayed.
Press the Exit function key (F3).
The Template Mapping panel is displayed showing the To column
BONUS is now not mapped to any From column.
Note:Db2® determines the default value
for an unmapped column according to the definition of the column in the
Db2® catalog.
Have feedback? Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.