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.