Deleting a repeatable item
Suppose you want to remove the repeatable item, STARTYEAR, from the previous GROUP BY clause:
- Move the cursor to the repeatable item, STARTYEAR
- Press Enter to make STARTYEAR the current repeatable item. Its color changes from yellow to green.
- Move the cursor to the groupingexpr fragment.
- Press the Deselect function key (F4). The repeatable item, STARTYEAR
(and its preceding repeat separator), is deleted from the GROUP BY
clause.
Process Options Utilities Help ────────────────────────────────────────────────────────────────────────────── FM/Db2 (DFG2) Advanced SELECT Prototyping Prototyping: group by clause Status: clause complete ◄─ , ────────────┐ ─ GROUP BY ─── groupingexpr ─┴─ GROUP BY SKILLTYPE , DEPT , EMPLEVEL 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