HP 3000 Manuals HP 3000 Manuals
UPDATE REPLACE
Modifies the value of data items.
Syntax
{U[PDATE] REPLACE,}
{REPL[ACE], } data item name [(subscript)] = "value";
[data item name [(subscript)] = "value";]... END
For example:
>UPDATE REPLACE,DATE="741010";END
Where data item name = DATE and value = "741010"
Parameters
data item name is the name of a simple data item, or the name of
a compound data item with an optional subscript
parameter, contained in the entries selected by
the last FIND command.
"value" is the new value for the data item surrounded by
quotation marks. It must be the proper size and
type for the named item. Quotation marks are
required. QUERY prints an error message if values
of improper size or type are entered.
subscript is the number indicating which sub-item you want
to replace. Subscript is entered with parenthesis
and must be an integer > 1 and <= the number of
sub-items defined for the compound item. QUERY
will default to the first sub-item if no subscript
is specified.
Discussion
UPDATE REPLACE is an extension of the retrieval commands in that it
operates on data entries selected by the previous retrieval command. All
of the data entries selected must be from the same set. UPDATE REPLACE
can only be used following a FIND or FIND ALL command or a SUBSET command
following a FIND or FIND ALL command. Entering a FIND CHAIN or MULTIFIND
command (which selects entries from a detail set and one or more master
data sets) followed by an UPDATE REPLACE command is not allowed.
You must have specified a mode of 1, 2, 3, or 4 to use this command.
QUERY does not allow you to modify items in the data base defined as
search or sort items.
The UPDATE REPLACE command consists of a series of data item name/data
item value pairs separated by semicolons. When the command is entered,
QUERY replaces the value of each data item named in the command with the
new value enclosed in quotation marks. The names of data items appearing
in the command must belong to the data entries selected by the last
retrieval command.
In a procedure, you must use the UPDATE REPLACE form of the command.
UPDATE can be abbreviated. REPLACE cannot be abbreviated when used with
the UPDATE keyword.
If an IMAGE error occurs during the replacement of data entries, QUERY
issues the following message to indicate how many entries were
successfully updated before the error occurred:
X OF Y ENTRIES REPLACED
X is the number of entries that were successfully updated, and Y is
number of retrieved entries.
Session Mode
When you enter an UPDATE REPLACE command from a terminal, QUERY checks
each line of the command as it is entered. If an error occurs, the line
is ignored, an error message is sent, and you are prompted for another
line. QUERY continues to prompt for lines until you enter END. END is
required.
The replacement statements (data item name/data item value pairs) can be
entered on one line:
>UPDATE REPLACE,DATE="851010";HOURS="4";END
or on several lines:
>UPDATE REPLACE,
>>DATE="851010";
>>HOURS="4";
>>END
>
Job Mode
If you are entering the command in job mode, the replacement statements
can appear in one record or several consecutive records. If an error
occurs, either illegal data or an IMAGE error, QUERY will terminate.
Null Values
You can store an UPDATE REPLACE command as a procedure with null values
for the data items. You do this by entering a pair of quotation marks
with no intervening characters data item name= (for example, DATE="").
When such a procedure is executed using the UPDATE procedure name
command, QUERY prompts you for a value by printing the message:
WHAT IS THE VALUE OF data item name
>>
Where data item name is the name of the data item associated with the
null value in the UPDATE REPLACE command. The desired value must be
entered without quotation marks. All characters entered (including
blanks, quotation marks, and other characters) are significant. The
maximum number of characters which can be entered as a value is 72.
Lowercase characters are upshifted unless the data item is type X.
Examples
Example 1
>F CUSTOMER.FIRST-NAME=GENEVA
USING SERIAL READ
1 ENTRIES QUALIFIED
>REPL,STREET-ADDRESS="868 DOYLE ROAD";
>>END
>LIST CUSTOMER FOR FIRST NAME=GENEVA
ACCOUNT LAST-NAME FIRST-NAME IN STREET-ADDRESS
10034764 SLATER GENEVA 868 DOYLE ROAD
In example 1, the CUSTOMER entry with FIRST-NAME of GENEVA is located.
The street address is changed. The LIST command is used to check the
results.
Example 2
>AD SALES
ACCOUNT =>>67795400
STOCK# =>>1169331
QUANTITY =>>6
PRICE =>>1800
TAX =>>RETURN
TOTAL =>>RETURN
PURCH-DATE =>>121585
DELIV-DATE =>>121685
ACCOUNT =>>//
>F SALES.ACCOUNT IS 67795400
1 ENTRIES QUALIFIED
>UPDATE REPLACE,
>>TAX="25";
>>TOTAL="1825";
>>END
The UPDATE REPLACE command can also be used to fill in blank values. In
the second example, no values are entered for TAX and TOTAL when the
entry is added. The UPDATE REPLACE command is then used to add these
values, after the entry has been located with the FIND command.
Example 3
>FIND PRODUCT.STOCK# IGT 70000000
USING SERIAL READ
3 ENTRIES QUALIFIED
>UPDATE REPLACE,
>>DESCRIPTION="OBSOLETE";
>>END
>REPORT ALL
STOCK# =7931Z22F
DESCRIPTION =OBSOLETE
STOCK# =78787878
DESCRIPTION =OBSOLETE
STOCK# =98989898
DESCRIPTION =OBSOLETE
In example 3, REPORT ALL is used to verify the replacements. The entries
are still available from the last FIND. Each PRODUCT data set entry with
a STOCK# greater than 70000000 is changed so that the description is
OBSOLETE.