REPLACE(QUEL) 2/29/79 REPLACE(QUEL) NAME replace - replace values of domains in a relation SYNOPSIS replace tuple_variable (target_list) [where qual] DESCRIPTION Replace changes the values of the domains specified in the target_list for all tuples which satisfy the qualification qual. The tuple_variable must have been declared to range over the relation which is to be modified. Note that a tuple variable is required and not the relation name. Only domains which are to be modified need appear in the target_list. These domains must be specified as result_attnames in the target_list either explicitly or by default (see quel(quel)). Numeric domains may be replaced by values of any numeric type (with the exception noted below). Replacement values will be converted to the type of the result domain. Only the owner of a relation, or a user with replace pemission on the relation can do replace. If the tuple update would violate an integrity constraint (see integrity(quel)), it is not done. EXAMPLE /* Give all employees who work for Smith a 10% raise */ range of e is emp replace e(sal = 1.1 * e.sal) where e.mgr = "Smith" SEE ALSO integrity(quel), permit(quel), quel(quel), range(quel) DIAGNOSTICS Use of a numeric type expression to replace a character type domain or vice versa will produce diagnostics. BUGS - 1 -