 |
» |
|
|
|
|  | |
Inserts, replaces, and deletes lines of a procedure stored in the current Proc-file. Syntax | |
For example: Where procedure name = REP22 Parameter | |
- procedure name
is the name of a procedure stored in the current Proc-file.
Discussion | |
When you enter the ALTER command, QUERY prompts you for insert, replace, and delete statements by printing >>. Each statement operates on a line or range of lines in the procedure. In the statement descriptions that follow, m is the first line number in the range, and n is the last line number. n must always be greater than or equal to m, and m must be greater than or equal to 1. Neither m nor n can exceed the total number of lines in the procedure. Once you enter the ALTER command, you must do your editing sequentially from lower numbered lines to higher numbered lines. You cannot go back to a line which precedes the ones you are currently editing without exiting the ALTER command and entering another ALTER command. This technique is illustrated in the examples which follow. If an error occurs after a statement is entered, an error message is printed and QUERY prompts you for another ALTER statement. You can abort the command at any time by entering CONTROL Y. If you do this, the procedure will remain unchanged. Always terminate the command with /E if you want to save the results of your changes. You can use one of four statements in response to an ALTER prompt: Insert, Replace, Delete, and End. Lines which are added or changed are not checked for correct syntax until the procedure is executed. Similarly, if line deletion causes a command to have incorrect syntax, it not will be detected until the procedure is executed. ALTER - INSERT STATEMENT | |
Inserts lines into the procedure. QUERY prompts for each statement and line with >>. Syntax | |
>>/I, m >>line >>line . .
|
Parameters | |
- m
is the number of the procedure line after which you want to insert statements. - line
is the new line you want to insert.
Discussion | |
The lines which follow the insert statement are inserted into the procedure following line number m. You cannot insert lines in front of the first procedure line. To indicate you do not want to insert mores lines, enter a slash followed by another ALTER statement. Example | |
>ALTER FIND1
>>/I,1
>>STOCK# IS "" AND
>>LASTSHIPDATE IS ""
>>/E
|
The example above changes the procedure FIND1 from:
text
001 FIND
002 END
To:
001 FIND
002 STOCK# IS "" AND
003 LASTSHIPDATE IS ""
004 END
|
ALTER - REPLACE STATEMENT | |
Deletes the specified line or range of lines and replaces them with the lines following the replace statement. QUERY prompts for each statement and line with >>. Syntax | |
>>/R,m[,n](current lines m through n are listed)>>replacement line>>replacement line . .
|
Parameters | |
- m
is the number of the first procedure line you want to replace. - n
is the number of the last procedure line you want to replace. If n is not specified, only line m is replaced. - replacement line
is the new line which will replace the existing line.
Example | |
>>ALTER UPDATE1
>>/R,2,3
HOURS="";
DATE="851022";
>>HOURS="14";
>>DATE="851101";
>>STATUS="OK";
|
The example above changes the procedure UPDATE1 from:
text
001 UPDATE REPLACE,
002 HOURS="";
003 DATE="851022";
004 END
To:
001 UPDATE REPLACE,
002 HOURS="14";
003 DATE="851101";
004 STATUS="OK";
005 END
|
ALTER - DELETE STATEMENT | |
Deletes the specified line or range of lines. QUERY prompts for each statement with >>. Syntax | |
>>/D,m [,n](deleted lines are listed)
|
Parameters | |
- m
is the first line you want to delete. - n
is the last line you want to delete. If n is not specified, only line m is deleted. If line n is specified, the range of lines from m to n is deleted.
Discussion | |
If you try to delete all the lines in the procedure, an error message is printed. To delete the entire procedure, use the DESTROY command. Example | |
text
>ALTER REPORT4
>>/D,4,5
S2,ORDERDATE
S,LASTSHIPDATE
>>/E
The example above changes the procedure named REPORT4 from:
001 REPORT
002 H1,"MONTHLY SHIPMENTS",25,SPACE A2
003 S1,STOCK#
004 S2,ORDERDATE
005 S,LASTSHIPDATE
006 G1,STOCK#,15
007 END
To:
001 REPORT
002 H1,"MONTHLY SHIPMENTS",25,SPACE A2
003 S1,STOCK#
004 G1,STOCK#,15
005 END
|
ALTER - END STATEMENT | |
Terminates the ALTER command and saves the procedure. Syntax | |
Discussion | |
QUERY continues to prompt you for insert, delete, or replace statements until you enter /E. If the ALTER command is terminated using CONTROL Y, the entire command is ignored and the procedure remains in its original state. To save your changes, you must terminate the ALTER command with /E. Example | |
text
>DISPLAY REPORT2
PROCEDURE: REPORT2
001 REPORT
002 H1,"AS OF:",6
003 H1,DATE,15
004 H2,"BOBO'S MERCANTILE",45
005 H1,"PAGE",69
006 H1,PAGENO,71
007 D1,STOCK#,36
008 D1,LASTSHIPDATE,48,E2
009 E2,"XX/XX/XX"
010 END
|
The following is an example of using the ALTER command with all
four statements. The DISPLAY command can be used to examine
the procedure and the results of the ALTER command.
>ALTER REPORT2
>>/R,2,3
H1,"AS OF:",6
H1,DATE,15
>>H1,"TO DATE:",6
>>H1,DATE,20
>>/D,5,6
H1,"PAGE",69
H1,PAGENO,71
>>I/,9
>>S,LASTSHIPDATE
>>/E
>
>DISPLAY REPORT2
PROCEDURE: REPORT2
001 REPORT
002 H1,"TO DATE:",6
003 H1,DATE,20
004 H2,"BOBO'S MERCANTILE",45
005 D1,STOCK#,36
006 D1,LASTSHIPDATE,48,E2
007 E2,"XX/XX/XX"
008 S,LASTSHIPDATE
009 END
|
|
