Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

7.125 UPDATE

Note
titleNote: Usage options

The UPDATE command allows the field(s) in record(s) in a file to be updated.

Portability Considerations

Refer to the parameters: AUTOCOMMIT, FIELDS and IN_FILE .

Also See

7.125.1 UPDATE Parameters

7.125.2 UPDATE Comments / Warnings

7.125.3 UPDATE Examples

                                                         Required

...


Panel
bgColor#ffffcc

                                                                                                Required

  UPDATE --------- FIELDS -----

...

---- field name    field attributes ---

...

--->

                                |           |               | |

                                |            --- 7 max -----  |

                                |*ALL                         |

                                |*ALL_REAL                    |

                                |*ALL_VIRT                    |

                                |*EXCLUDING                   |

                                |*INCLUDING                   |

                                |expandable group             |

                                |                             |

...

                                                       |                     |                     |       |
                                                       |                      --- 7 max ---        |
                                                       |*ALL                                            |
                                                       |*ALL_REAL                                   |
                                                       |*ALL_VIRT                                   |
                                                       |*EXCLUDING                              |
                                                       |*INCLUDING                              |
                                                       |expandable group                      |
                                                       |                                                  |
                                                       |------

...

1000 max for RDMLX-----|

...

                                                         -------

...

100 max for RDML ----

...

                      >--

...

IN_FILE ---------

...

file name .

...

*

...

FIRST ----------------->

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

...

--------

                                                                                              Optional

                      >-- WITH_KEY ----- key value ----

                                                         Optional

...

---------------------->

                               |expandable group expression|

...

                                                    | expandable group expression |
                                                     ---------

...

20 maximum -------

...

                       >--

...

IO_STATUS --- *STATUS ----

...

------------------------>

                                field name

...

                                                    field name

                      >-- IO_ERROR ---- *ABORT ----

...

------------------------->

...

                                                    *NEXT

...

                                                    *RETURN

                                command label

...

                                                    command label

                      >-- VAL_ERROR -- *LASTDIS -----

...

----------------------->

...

                                                   *NEXT

...

                                                   *RETURN

                                command label

...

                                                   command label

                     >-- NOT_FOUND - *NEXT -----

...

-------------------------->

...

                                                  *RETURN

                                command label

...

                                                   command label

                     >-- ISSUE_MSG -- *NO ------

...

---------------------------->

...

                                                  *YES

...

                     >--

...

WITH_RRN -- *NONE ------

...

-------------------------->

...

                     >--

...

RETURN_RRN - *NONE ----

...

-------------------------->

...

                     >--

...

CHECK_ONLY - *NO -----

...

---------------------------->

...

                                                    *YES

...

                     >-- AUTOCOMMIT - *FILEDEF --

...

---

...

-----------------------|

...

                                                     *YES

...

                                                     *NO