Using the CA Dataquery EDITOR › Entering a Sample Line Command

Entering a Sample Line Command

Operation

On the following sample EDITOR panel, note that the letter M has been typed over the zero of line 02. This tells the EDITOR to move line 02 to the line following the A typed over the zero of line 03.

 =>
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
 ----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   MOVE ONE LINE______________________________________________
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01 SELECT ITM_ID, ORD_ID, SHIP_QTY
 M2 WHERE SHIP_QTY > 10
 A3 FROM CAI_SLSHST_TBL
 04 ORDER BY ITM_ID
 .. ============================ B O T T O M ===================================




 -----------------------------------------------------------------------------
 <PF1>  HELP             <PF2>  RETURN    <PF3>  EXECUTE      <PF4>  SAVE
 <PF5>  DIALOG DEF       <PF6>  DELETE    <PF7>  BACKWARD     <PF8>  FORWARD
 <PF9>  UPDATE           <PF10> VALIDATE  <PF11> RIGHT/LEFT   <PF12> CREATE MODE

Result

The following example shows the results of moving line 02 to follow line 03.

 =>
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
-----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   MOVE ONE LINE______________________________________________
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01 SELECT ITM_ID, ORD_ID, SHIP_QTY
 02 FROM CAI_SLSHST_TBL
 03 WHERE SHIP_QTY > 10
 04 ORDER BY ITM_ID
 .. ============================ B O T T O M ===================================





 -------------------------------------------------------------------------------
 <PF1>  HELP            <PF2>  RETURN     <PF3>  EXECUTE    <PF4>  SAVE
 <PF5>  DIALOG DEF      <PF6>  DELETE     <PF7>  BACKWARD   <PF8>  FORWARD
 <PF9>  UPDATE          <PF10> VALIDATE   <PF11> RIGHT/LEFT <PF12> CREATE MODE

See the CA Dataquery Reference Guide for complete instructions on EDITOR commands.