Changing a repeatable item

Suppose you want to change the name of the repeatable item, EMPGRADE, in the previous GROUP BY clause to EMPLEVEL:

1. Move the cursor to the groupingexpr fragment.
2. Press the NxtRpt function key (F11) to make EMPGRADE the current repeatable item. Its color changes from yellow to green.
3. 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

4. You can now edit the name of the column in the pop-up panel. Change it to EMPLEVEL.
5. 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