ADD – Add new object

The ADD action inserts a new object into the Output Manager Db2® database, and maintains cross-table links and references.

The ADD action inserts a new object into the Output Manager Db2 database, and maintains cross-table links and references. If ADD is specified in the H_ACT_REQ field of a row, the data definitions in the other columns of the row will be added as new data definitions in the Output Manager database. ADD can be used to easily clone existing objects. For an example of the ADD action, see the cloning example in the “Cloning Data” section.

The format of UBU files used for ADD must be in PREP4CLON(YES).
Note: Do not use the same flat file for a MOD or DEL operation after and ADD operation. Because the H_ROWID field changes after an ADD operation, you must re-extract data and work only with the new extraction.