Page 1 of 1

Tool to insert/delete/update records in a table?

PostPosted: Wed Nov 28, 2012 7:38 am
by sam_hyd_1122
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.

Re: Tool to insert/delete/update records in a table?

PostPosted: Wed Nov 28, 2012 3:42 pm
by Akatsukami
And how is this different from doing a LOAD REPLACE?