Using CREATE in DQL Mode › Creating the Sample Query › Step 6: Print or Display Report Data › Select a PRINT Statement

Select a PRINT Statement

To select a PRINT statement, follow these steps:

1. Type 1 in the space before the PRINT statement format.
2. Press <PF2> RETURN to return to the CREATE MODE panel.

The report is to be in columnar format, so the PRINT statement should be selected. The number 1 should be entered in the space since there can only be one PRINT verb in the query. Pressing <PF2> returns to the CREATE MODE panel where the PRINT format has been inserted as shown in the following panel.

 =>

 --------------------------------------------------------------------------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 =====================================
 01  FIND ALL  CAI-DETAIL-TBL ROWS
 02       WITH SHIP-QTY GT 0
 03  SET SHIP-PRICE(7.2) = UNIT-PRICE * SHIP-QTY
 04  SORT BY (CUST-ID)
 05  PRINT FROM table-name     ROWS
 06       column-name ('optional-heading') (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