Using CREATE in DQL Mode › Creating the Sample Query › Step 7: Specify Mathematical Function › Select WHEN/DO

Select WHEN/DO

To select a WHEN/DO statement:

1. Type 1 in the space before the WHEN/DO format.
2. Press <PF2> RETURN to return to the CREATE MODE panel.

Typing 1 indicates that only one WHEN/DO format is needed in the query. Pressing <PF2> returns the Create mode panel where the format has been inserted for editing.

 =>

 --------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR            CURRENT TABLE:  CAI-DETAIL-TBL
 -------------------------------------------------------------------------------
 NAME:              USER-SAMPLE                          TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   TOTAL ORDERS PER CUSTOMER -- AVERAGE PRICE
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 10         (SHIP-PRICE) PICTURE 'Z,ZZZ,ZZ9.99-'
 11  WHEN named-control-break-object FINISHED  BREAKS
 12  DO 'legend-for-display'  function  column-name (PICTURE 'picture-clause')
     ======================= B O T T O M =======================================






 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2>  RETURN     <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS
 <PF5> DISPLAY ALL <PF6>  LIST TABLES<PF7> BACKWARD        <PF8> FORWARD
 <PF9> TEMPLATE    <PF10> VALIDATE   <PF11> RIGHT/LEFT     <PF12>PROCESS MODE