Inserting an extra repeatable item

Suppose you need to insert an extra repeatable item (department) in the previous GROUP BY clause so that the information is grouped by their skill type, department, level, and the year they started:

1. Move the cursor to the SKILLTYPE repeatable item (that is to precede the new repeatable item) in the GROUP BY clause.
2. Press Enter to make SKILLTYPE the current repeatable item. Its color changes from yellow to green.
3. Move the cursor to the groupingexpr fragment.
4. Press the InsRpt function key (F5). A pop-up panel is displayed in which you can enter a column name.
5. Type DEPT in the pop-up panel.
6. Press the Exit function key (F3). The repeat separator and the new repeatable item, DEPT, are added to the GROUP BY statement after the SKILLTYPE repeatable item.

     Process   Options   Utilities   Help
    ──────────────────────────────────────────────────────────────────────────────
    FM/Db2 (DFG2)            Advanced SELECT Prototyping
   
    Prototyping: group by clause                      Status: clause complete
   
                ◄─ , ────────────┐
    ─ GROUP BY ─── groupingexpr ─┴─
   
   
   
   
   
   
   
   
   
    GROUP BY SKILLTYPE , DEPT , EMPGRADE , STARTYEAR
   
   
   
    Command ===> _____________________________________________________ Scroll PAGE
     F1=Help      F2=Split     F3=Exit      F4=Deselect  F5=InsRpt    F6=Executed
     F7=Backward  F8=Forward   F9=Swap     F10=PrvRpt   F11=NxtRpt   F12=Cancel