Step 4. Use the FM/Db2 editor (normal and related edit)
Log on to FM/Db2, and connect to the same Db2® system specified in Step 1. Define Db2 objects to be used during verification. Select the FM/Db2 editor by typing '2' on the FM/Db2 main menu. Press Enter. Figure 1. Db2® Edit panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Db2 Edit
Command ===>
Db2 Object:
Location . . . . . Database . . . (optional)
Owner . . . . . . . FMNCUSR + Table Space . . (optional)
Name . . . . . . . * +
Start position . . 1
Row count . . . . . 100 Number of rows to edit
Template:
Data set name . . .
Member . . . . . .
Processing Options:
Template usage Enter "/", "A"lways to select option
3 1. Above Edit options
2. Previous Edit template
3. Generate from table Re-edit template
4. Generate/Replace / Create audit trail (Option fixed)
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
See Db2 Edit panel. Enter the values shown in the figure, FMNCUSR in the Owner field and '*' in the Name field.
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Table Edit Commit issued (Errors)
Command ===> Scroll CSR
TABLE FMNCUSR.Department-Information Format TABL
Department Code Department Name Manager Employee N
#1 #2 #3
CHARACTER(3) VARCHAR(36) CHARACTER(6)
PU> <---+----1----+----2----+----3----+> <-N-+>
****** **** Top of data ****
000001 S00 Spiffy Computer Service Division< 000010
=ERR R P01 Planning Department< XXXXXX
000003 I01 Information Center< 000030
000004 D01 Development Center< _
⋮
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
The change to the Manager Employee Number could not be saved. The row in error is marked with '=ERR R'.
Overtype 'e' in the prefix area for this row and press Enter. See Table Edit with amended Manager Employee number.
Figure 6. Table Edit with amended Manager Employee number
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Table Edit Commit issued (Errors)
Command ===> Scroll CSR
TABLE FMNCUSR.Department-Information Format TABL
Department Code Department Name Manager Employee N
#1 #2 #3
CHARACTER(3) VARCHAR(36) CHARACTER(6)
PU> <---+----1----+----2----+----3----+> <-N-+>
****** **** Top of data ****
000001 S00 Spiffy Computer Service Division< 000010
E RR R P01 Planning Department< XXXXXX
000003 I01 Information Center< 000030
000004 D01 Development Center< _
⋮
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
FM/Db2 displays the error panel shown in Db2 Save Error Action panel.
Type the REDIT command on the command line, and press Enter. See Table Edit (related) panel to display the parent table for the relationship.Figure 7. Db2® Save Error Action panel
Process Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Db2 Save Error Action
Command ===>
Db2 reported a No Primary Key error while attempting to save this row. See
below for key column details.
Relationship : Manager must be Employee
Parent table : FMNCUSR.Employee-Detail
Dependent table : FMNCUSR.Department-Information
Explanation: The insert or update operation on this line would have resulted
in a foreign key value for which there is no corresponding primary key value.
Instructions: Type REDIT on the command line to edit the parent table shown
above. Press ENTER or enter EXIT to return to the edit session and correct
the error. Press the CANCEL key to terminate the edit session. Any changes
made since the last commit point will be lost.
Parent Column Name Depndnt Column Name Value
Employee Number Manager Employee Num XXXXXX
F1=Help F2=Split F3=Exit F4=Expand F7=Backward F8=Forward
F9=Swap F10=Left F11=Right F12=Cancel
Figure 8. Table Edit (related) panel
Process Options Utilities Help
──────────────────────────────────────────────────────────────────────────────FM/Db2 (DFF2) Table Edit (related) Parent table
48 rows - End of object. Format TABL
Employee Number First Name Middle Initial Last Name Work Depart
#1 #2 #3 #4 #5
CHARACTER(6) VARCHAR(12) CHARACTER(1) VARCHAR(15) CHARACTER(3
PU--+> <---+----1-> - <---+----1----> <-N
****** **** Top of data ****
000001 000010 Xena< B Howard< S00
000002 000020 Michelle< J Jackson< P01
000003 000030 James< Z Jones< I01
000004 000050 Jo-anne< G Gratten< S11
000005 000060 Jackson< P Costello< M10
000006 000070 Charles< A Abercrombie< A10
000007 000090 Eleni< MacMahon< D11
000008 000100 Junichi< K Funahashi< S12
000009 000110 Luigi< V Andretti< S00
000010 000120 Patrick< O O'Farrelly< S00
000011 000130 Megumi< Takami< I01
Command ===> Scroll CSR
F1=Help F2=Zoom F3=Exit F4=CRetriev F5=RFind F6=RChange
F7=Up F8=Down F9=Swap F10=Left F11=Right F12=Cancel
Press PF3 to exit from the FM/Db2 edit session of the
Employee-Detail table and return to the FM/Db2 edit session of the
Department-Information table. Press PF12 (CANCEL) to return to the FM/Db2 Editor function entry panel. A pop-up panel is displayed asking for
confirmation to cancel the operation. Press Enter to continue.