Changing a repeatable item
Suppose you want to change the name of the repeatable item, EMPGRADE, in the previous GROUP BY clause to EMPLEVEL:
- Move the cursor to the groupingexpr fragment.
- Press the NxtRpt function key (F11) to make EMPGRADE the current repeatable item. Its color changes from yellow to green.
- Press Enter. A pop-up panel is displayed showing the repeatable
item EMPGRADE already entered.
Process Options Utilities Help ─ ┌────────────────────── Freeform Entry ───────────────────────┐ ──────────── F │ │ │ Enter a column name to be inserted in the SQL: │ P │ EMPGRADE___________________________________________________ │ te │ ___________________________________________________________ │ ─ │ ___________________________________________________________ │ │ ___________________________________________________________ │ │ ___________________________________________________________ │ │ Command ===> _________________________________ Scroll PAGE │ │ F1=Help F2=Split F3=Exit F7=Backward │ │ F8=Forward F9=Swap F12=Cancel │ └─────────────────────────────────────────────────────────────┘ 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
- You can now edit the name of the column in the pop-up panel. Change
it to
EMPLEVEL
. - Press the Exit function key (F3). EMPGRADE is replaced by EMPLEVEL
in the GROUP BY statement.
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 , 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