7.9 CHANGE
The CHANGE command is used to change the value(s) of a field(s).
The FIELD parameter specifies the name of the field or fields that are to have their contents changed by the command.
Optionally the FIELD parameter may specify a group name or an expandable group expression which indirectly indicates that a group or list of fields are to have their contents changed by the command.
When the FIELD parameter nominates a group or list name, rather than specific field(s), the VALUE parameter may only be one of the special values *NULL, *SQLNULL, *DEFAULT, *NAVAIL, *LOVAL or *HIVAL. This constraint doesn't apply when an expandable group expression is used, as the expression is replaced by the fields themselves.
The VALUE parameter allows an expression to be specified that is used to change the contents of the field(s) nominated in the FIELD parameter.
|
Portability Considerations |
Refer to Parameters: PRECISION, ROUND_UP and TO. Refer also to Portability Specifics in the . |
Also See
7.9.2 CHANGE Comments/Warnings
Required
CHANGE ------- FIELD -------- field / list name(s) ----------->
expandable group expression
>-- TO ----------- value -------------------------->
-----------------------------------------------------------------
Optional
>-- PRECISION ---- *COMPUTE ---- *COMPUTE --------->
total digits total decimals
>-- ROUND_UP ----- *NO ----------------------------|
*YES