SP (Split)

Summary

The following table summarizes the SPLIT command.

Command	Action	Result
SP	Enter SP in the line number column of the line you want to split.	Splits the line into two lines as indicated by your cursor position.

Description

Use the SPLIT line command to split text from one line into two lines.

Action

Enter the SPLIT command in the line number column, move the cursor to the point you want the line split, and press Enter. CA Dataquery splits the text into two lines.

Example—Split a Line

 =>
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
 -----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION: SPLIT A LINE
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01 FIND 10 CAI-SLSHST-REC
 02 WITH SHIP-QTY > 100
 03 RELATED BY ITM-ID TO CAI-RCPTS-REC
 SP       */THIS PART OF THE QUERY  CREATES NEW TEMPORARY RESULTS*/

Result

 =>
 ------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR
 -----------------------------------------------------------------------------
 NAME:          SAMPLE                            TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   SPLIT A LINE
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01 FIND 10 CAI-SLSHST-REC
 02 WITH SHIP-QTY > 100
 03 RELATED BY ITM-ID TO CAI-RCPTS-REC
 04       */THIS PART OF THE QUERY
 05                                CREATES NEW TEMPORARY RESULTS*/
 06 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE
 07 SET DISCOUNT (5.2) = NET-COST * DISC-PCT
 08 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT
 09 SORT CAI-RCPTS-REC BY (ITM-ID)
 10 CAI-SLSHST-REC BY (ITM-ID)
 11 CAI-SLSHST-REC BY (ITM-ID)
 -----------------------------------------------------------------------------
 <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