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:
- Move the cursor to the SKILLTYPE repeatable item (that is to precede the new repeatable item) in the GROUP BY clause.
- Press Enter to make SKILLTYPE the current repeatable item. Its color changes from yellow to green.
- Move the cursor to the groupingexpr fragment.
- Press the InsRpt function key (F5). A pop-up panel is displayed in which you can enter a column name.
- Type
DEPT
in the pop-up panel. - 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