IBM Mainframe Forum

Researching to see if there is actually any tool which can insert/delete/update records in a table.

in current situation, we are writing cobol-db2 programs to do insert/update/delete on DB.
but just wanted to know if there is any tool which can modify the table by taking input from a flat file.

a record can be read from a flat file, check on the unique key and insert if the record is not found. update the record if a match is found.

if there is actually one like this, it can reduce the development effort.

any ideas, suggestions, references will be very helpful.

thanks in anticipation.

And how is this different from doing a LOAD REPLACE?