Previous Topic: PR (Locate Previous)Next Topic: R (Repeat)


M (Move)

Summary

The following table summarizes the MOVE command.

Command

Action

Result

M

Enter an M in the line number column of the line you want to move and specify a destination.

Moves a single line to the specified destination.

MB

Enter MB in line number column
of the line on which you want the copy to begin and specify a destination.

Moves the block of text starting with the line on which you entered the MB command through the end of the text. Blank lines found at the end of the text are not moved.

MM

Enter MM in the first line and the last line of the block you want to define. Specify a destination.

Moves the block of text to a specified destination.

Mn

Enter an M on the first line of the block along with the number of lines you want to include in this block and specify a destination.

Moves the specified number of lines starting with the line on which you entered the MOVE command.

MT

Enter the MT command in the line number column of the line on which you want the block to end. CA Dataquery assumes the block begins with line 01.

Moves the block of text starting with line 01 and continuing through the text to the line which contains the MT command. The line which contains the MT is included.

Description

Use the MOVE command to move lines of text from one location to another.

Action

Enter the MOVE commands in the line number column. Use an A or B to specify the destination of the move. A places the moved lines after the line on which you specify the A. B places the moved lines before the line on which you specify the B. The A or B must be placed in the first position of the line number column. The destination cannot be inside the defined block.

To cancel a block command, type an X in the first position of any line number column.

Example—Move One Line

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE ONE LINE______________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC M2 RELATED BY ITM-ID TO CAI-RCPTS-REC A3 WITH SHIP-QTY > 100 04 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE 05 SET DISCOUNT (5.2) = NET-COST * DISC-PCT 06 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT 07 SORT CAI-RCPTS-REC BY (ITM-ID) 08 CAI-SLSHST-REC BY (ITM-ID) 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 10 FROM CAI-SLSHST-REC ITM-ID 11 SHIP-QTY ----------------------------------------------------------------------------- <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

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE ONE 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 SET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE 05 SET DISCOUNT (5.2) = NET-COST * DISC-PCT 06 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT 07 SORT CAI-RCPTS-REC BY (ITM-ID) 08 CAI-SLSHST-REC BY (ITM-ID) 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 10 FROM CAI-SLSHST-REC ITM-ID 11 SHIP-QTY ----------------------------------------------------------------------------- <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

Example—Move a Block

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE A BLOCK_______________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== A1 FIND 10 CAI-SLSHST-REC 02 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 03 FROM CAI-SLSHST-REC ITM-ID 04 SHIP-QTY 05 UNIT-PRICE 06 (NET-COST) 07 DISCOUNT MM WITH SHIP-QTY > 100 09 RELATED BY ITM-ID TO CAI-RCPTS-REC 10 SORT CAI-RCPTS-REC BY (ITM-ID) MM 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

Result

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE A BLOCK ____________________________________________ ....+....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 SORT CAI-RCPTS-REC BY (ITM-ID) 05 CAI-SLSHST-REC BY (ITM-ID) 06 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 07 FROM CAI-SLSHST-REC ITM-ID 08 SHIP-QTY 09 UNIT-PRICE 10 (NET-COST) 11 DISCOUNT ----------------------------------------------------------------------------- <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

Example—Move All Following Lines

=> --------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ------------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE NEXT LINES____________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== A1 FIND 10 CAI-SLSHST-REC 02 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 03 FROM CAI-SLSHST-REC ITM-ID 04 SHIP-QTY 05 UNIT-PRICE 06 (NET-COST) 07 DISCOUNT MB WITH SHIP-QTY > 100 09 RELATED BY ITM-ID TO CAI-RCPTS-REC 10 SORT CAI-RCPTS-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

Result

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE NEXT LINES____________________________________________ ....+....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 SORT CAI-RCPTS-REC BY (ITM-ID) 05 CAI-SLSHST-REC BY (ITM-ID) 06 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 07 FROM CAI-SLSHST-REC ITM-ID 08 SHIP-QTY 09 UNIT-PRICE 10 (NET-COST) 11 DISCOUNT ----------------------------------------------------------------------------- <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

Example—Move Multiple Lines

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE MULTIPLE LINES________________________________________ ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC 02 WITH SHIP-QTY > 100 A3 RELATED BY ITM-ID TO CAI-RCPTS-REC 04 SORT CAI-RCPTS-REC BY (ITM-ID) 05 CAI-SLSHST-REC BY (ITM-ID) M3 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 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 10 FROM CAI-SLSHST-REC ITM-ID 11 (DISCOUNT-COST) ----------------------------------------------------------------------------- <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

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE MULTIPLE LINES________________________________________ ....+....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 NET NET-COST (8.2) = CAI-SLSHST-REC SHIP-QTY * UNIT-PRICE 05 SET DISCOUNT (5.2) = NET-COST * DISC-PCT 06 SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT 07 SORT CAI-RCPTS-REC BY (ITM-ID) 08 CAI-SLSHST-REC BY (ITM-ID) 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 10 FROM CAI-SLSHST-REC ITM-ID 11 (DISCOUNT-COST) ----------------------------------------------------------------------------- <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

Example—Move Previous Lines

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: CAI-SLSHST-REC ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE FIRST LINES TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 IND-CD 02 CUST-ID 03 DISC-PCT 04 UNIT-PRICE 05 SHIP-QTY 06 ORD-QTY 07 ORD-DAY MT ORD-MO 09 FIND ALL CAI-SLSHST-REC A0 PRINT .. =========================== 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

Result

=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR CURRENT TABLE: CAI-SLSHST-REC ----------------------------------------------------------------------------- NAME: SAMPLE TYPE: QUERY STATUS: PRIVATE DESCRIPTION: MOVE FIRST LINES TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND ALL CAI-SLSHST-REC 02 PRINT 03 IND-CD 04 CUST-ID 05 DISC-PCT 06 UNIT-PRICE 07 SHIP-QTY 08 ORD-QTY 09 ORD-DAY 10 ORD-MO .. =========================== 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