Summary
The following table summarizes the COPY command.
|
Command |
Action |
Result |
|---|---|---|
|
C |
Enter a C in the line number of the line you want to copy and specify the new destination using an A or B destination command. |
Copies the designated line to the destination you indicate. |
|
Cn |
Enter a C and the number of lines you want to copy and specify a number for the total number of lines to copy. |
Copies the indicated number of lines including the line on which the destination command was entered. |
|
CB |
Enter the CB command on the line where you want the copy to begin. Specify a destination. The destination cannot be in the block. |
Copies all lines following the command through the end of the text. Blank lines found at the end of the text are not copied to the destination. |
|
CC |
Enter CC in the line number column of the first line of the block you want to copy. Then enter CC in the line number column of the last line of the block you want to copy. |
Copies the defined block to the destination you indicate. |
|
CT |
Enter the CT command in the line number column of the line through which you want to copy. Specify a destination. The destination of the copy cannot be within the block. |
Copies the first line of the text through the line on which the CT command is entered. |
Note: CA Dataquery does not allow you to complete a copy if the copy operation would force lines which contain text to shift beyond the maximum number of lines specified in your Option Table.
Description
You can use the COPY command to duplicate lines in the query text.
Action
Enter the command in the first position of the line number column in the source and specify the destination by entering an A (AFTER) or B (BEFORE) in the line number column of the destination. Specifying an A places the copied lines after the line on which the A is placed. B specifies that the copied lines are placed before the line on which you placed the B.
Note: The A or B line commands must be placed in the first position of the two-position line command area.
Example—Copy a Line
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY A LINE TO ANOTHER LOCATION ....+....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 A SET DISCOUNT-COST (8.2) = NET-COST - DISCOUNT 07 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 08 FROM CAI-SLSHST-REC ITM-ID C9 SHIP-QTY 10 UNIT-PRICE 11 (NET-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-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY A LINE TO ANOTHER LOCATION ....+....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 SHIP-QTY 08 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 09 FROM CAI-SLSHST-REC ITM-ID 10 SHIP-QTY 11 UNIT-PRICE 12 (NET-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—Copy Multiple Lines
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY LINES TO ANOTHER LOCATION ....+....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 c2 SHIP-QTY 08 UNIT-PRICE 09 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' a0 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-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY LINES TO ANOTHER LOCATION ....+....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 PRINT FROM CAI-RCPTS-REC ITM-ID 'ORD-ID' 08 FROM CAI-SLSHST-REC ITM-ID 09 SHIP-QTY 10 UNIT-PRICE 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—Copy Remaining Lines
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY ALL FOLLOWING LINES ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC A2 WITH SHIP-QTY > 100 03 RELATED BY ITM-ID TO CAI-RCPTS-REC 04 PRINT FROM CAI-SLSHST-REC 05 ORD-QTY 06 ORD-DAY 07 ORD-MO CB ORD-YR 09 ORD-DT .. =========================== 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
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY ALL FOLLOWING LINES ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC 02 WITH SHIP-QTY > 100 03 ORD-YR 04 ORD-DT 05 RELATED BY ITM-ID TO CAI-RCPTS-REC 06 PRINT FROM CAI-SLSHST-REC 07 ORD-QTY 08 ORD-DAY 09 ORD-MO 10 ORD-YR 11 ORD-DT ----------------------------------------------------------------------------- <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—Copy a Block
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY A BLOCK TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC A2 WITH SHIP-QTY > 100 03 PRINT FROM CAI-SLSHST-REC CC ORD-QTY 05 ORD-DAY CC ORD-MO 07 ORD-YR 08 ORD-DT .. =========================== 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
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: COPY A BLOCK TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC 02 WITH SHIP-QTY > 100 03 ORD-QTY 04 ORD-DAY 05 ORD-MO 06 PRINT FROM CAI-SLSHST-REC 07 ORD-QTY 08 ORD-DAY 09 ORD-MO 10 ORD-YR 11 ORD-DT ----------------------------------------------------------------------------- <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—Copy Previous Lines
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: A-CUST-CITY-DIA TYPE: DIALOG STATUS: PUBLIC DESCRIPTION: COPY ALL PREVIOUS LINES TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 */THIS PART OF THE DIALOG ALLOWS YOU TO CHANGE CT ONLY THE/* 03 FIND 1?10 CAI-CUST-REC 04 WITH CITY = 2?'DALLAS' 05 PRINT TITLE1 'SAMPLE ORDER ENTRY DATABASE' A6 TITLE2 'CUSTOMER FILE' 07 NAME 08 ADDR-1 09 ADDR-2 10 CITY 11 STATE ----------------------------------------------------------------------------- <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: A-CUST-CITY-DIA TYPE: DIALOG STATUS: PUBLIC DESCRIPTION: COPY ALL PREVIOUS LINES TO ANOTHER LOCATION ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 */THIS PART OF THE DIALOG ALLOWS YOU TO CHANGE 02 ONLY THE/* 03 FIND 1?10 CAI-CUST-REC 04 WITH CITY = 2?'DALLAS' 05 PRINT TITLE1 'SAMPLE ORDER ENTRY DATABASE' 06 TITLE2 'CUSTOMER FILE' 07 */THIS PART OF THE DIALOG ALLOWS YOU TO CHANGE 08 ONLY THE 09 NAME 10 ADDR-1 11 ADDR-2 ----------------------------------------------------------------------------- <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
|
Copyright © 2014 CA.
All rights reserved.
|
|