Versions Compared

Key

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

7.78 INSERT

Note
titleNote: Usage options

The INSERT command is used to insert fields into a new record in a file.

Portability Considerations

Refer to parameters: AUTOCOMMIT and TO_FILE .

...

7.78.2 INSERT Comments / Warnings

7.78.3 INSERT Examples

                                                         Required

...


Panel
bgColor#ffffcc

                                                                Required

  INSERT --------- FIELDS ----

...

----- field name    field attributes --

...

--->

                                |           |               | |

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

                                |*ALL                         |

                                |*ALL_REAL                    |

                                |*ALL_VIRT                    |

                                |*INCLUDING                   |

                                |*EXCLUDING                   |

                                |expandable group             |

                                |                             |

...

                                                      |                    |                      |    |
                                                      |                      --- 7 max —      |
                                                      |  *ALL                                       |
                                                      |  *ALL_REAL                              |
                                                      |  *ALL_VIRT                              |
                                                      |  *INCLUDING                         |
                                                      |  *EXCLUDING                         |
                                                      |  expandable group                 |
                                                      |                                               |
                                                      |---- 1000 max for RDMLX-----|

...

                                                       ----

...

100 max for RDML ------

...

                     >--

...

TO_FILE ---------

...

file name .

...

*

...

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

                                            library name

...

                                                                         library name

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

...

                                                         Optional

...

---

                                                                                            Optional

                    >-- IO_STATUS -------

...

*

...

STATUS ------------------------>

                                field name

...

                                                       field name

                   >-- IO_ERROR --------

...

*

...

ABORT ------------------------->

...

                                                       *NEXT

...

                                                      *RETURN

                                label

...

                                                       label

                  >-- VAL_ERROR ------

...

*

...

LASTDIS ------------------------->

...

                                                     *NEXT

...

                                                     *RETURN

                                label

...

                                                     label

                  >-- ISSUE_MSG ------

...

*

...

NO ------------------------------>

...

                                                     *YES

...

                  >--

...

RETURN_

...

RRN ---

...

*

...

NONE ---------------------------->

...

                  >--

...

CHECK_

...

ONLY ---

...

*

...

NO ------------------------------->

...

                                                   *YES

...

                 >-- AUTOCOMMIT -- *FILEDEF --

...

---

...

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

...

                                                   *YES

...

                                                   *NO