7.12 CHANGE

Note: Usage options

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 LANSA Application Design Guide.

Also See

7.12.1 CHANGE Parameters

7.12.2 CHANGE Comments/Warnings

7.12.3 CHANGE Examples

                                                         Required

 

  CHANGE ------- FIELD -------- field / list name(s) ----------->

                                expandable group expression      

 

             >-- TO ----------- value -------------------------->

 

 -----------------------------------------------------------------

                                                         Optional

 

             >-- PRECISION ---- *COMPUTE ---- *COMPUTE --------->

                               total digits  total decimals

 

             >-- ROUND_UP ----- *NO ----------------------------|

                                *YES