Tool to insert/delete/update records in a table?
Posted: Wed Nov 28, 2012 7:38 am
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.
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.