Summary
The following summarizes the CHANGE command.
Enter CH in the line number column. Enter the string you want to change as string1 in the text area, followed by the replacement string as string2.
For mass changes, see the GC command.
Description
The CHANGE command locates a string and changes it to another string. CA Dataquery locates and changes the first occurrence of the string found.
Action
Enter the CHANGE command in the first position of the line number column and tab over to the query entry area. Type your search string and replacement string over the existing text. The text you type over is not deleted. The string size limit is 32 characters. You can use any special character to delimit the strings. Any special character in position 1 of a query text line where CH appears in the line number column is interpreted as the string delimiter. Examples of special characters are:
? @ # % /
CA Dataquery changes the first occurrence of the located string. This includes the current line. To change the next occurrence place CH in the line number column and press Enter. You do not need to reenter the search and replacement strings.
Example—Changing First Occurrence
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. .. ================================ T O P ===================================== 01 FIND 10 CAI-SLSHST-REC ch /itm-id/ord-id/ > 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
Result
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. 03 RELATED BY ORD-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 12 UNIT-PRICE 13 (NET-COST) 14 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—Changing Next Occurrence
=> ------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ----------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. CH RELATED BY ORD-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 12 UNIT-PRICE 13 (NET-COST) 14 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
Result
=> --------------------------------------------------------------------------DQD10 DATAQUERY: EDITOR ------------------------------------------------------------------------------- NAME: SAMPLE-QUERY TYPE: QUERY STATUS: PRIVATE DESCRIPTION: SHOW EDITOR LINE COMMAND FUNCTIONS ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+. 07 SORT CAI-RCPTS-REC BY (ORD-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 12 UNIT-PRICE 13 (NET-COST) 14 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
|
Copyright © 2014 CA.
All rights reserved.
|
|