Database Access Commands › Logical Record Facility Commands › MODIFY

MODIFY

Purpose

Modifies field values in a record occurrence.

Syntax

►►─── MODIFY lr-name ────┬───────────────────────────────────┬────────────────►
                         └─ WHERE lr-conditional-expression ─┘

 ►──┬────────────────────┬───── . ────────────────────────────────────────────►◄
    └─ error-expression ─┘

Parameters

lr-name

Specifies the name of the logical record.

Lr-name must be known to the dialog's subschema.

WHERE lr-conditional-expression

Specifies the selection criteria to be applied to the logical record request.

Syntax for lr-conditional-expression is described earlier in this section.

error-expression

Specifies the status codes that are returned to the dialog.

Example

The statements in the following example update an occurrence of the logical record CUST-ORDER-LR by specifying a new customer name and a new required date for the associated order:

OBTAIN FIRST CUST-ORDER-LR
  WHERE CUST-NUMBER EQ '1234567890'
  AND ORD-NUMBER EQ '7654321'.
MOVE NEW-CUST-NAME TO CUST-NAME.
MOVE NEW-DATE-REQ TO ORD-DATE-REQ.
MODIFY CUST-ORDER-LR.

More information:

Error Handling