REPLACE (Replace All Data in a Table) › REPLACE

REPLACE

The REPLACE function of DBUTLTY provides the ability to load one table in a multiple table area with new data, replacing all current data for that table. It executes in the Multi-User Facility and allows full read and update access to every other table in the same area and database to other applications in the same Multi-User Facility. For example, you could extract a table that is not a partitioned table, redefine it to be a partitioned table, and use the REPLACE function to populate it, provided all the other rules are met, such as the table to be replaced not being the only table in an area.

FILEIN may be used before a REPLACE. See FILEIN (Concatenate Input).