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



IBM's flagship relational database management system

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

Postby sam_hyd_1122 » 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.
sam_hyd_1122
 
Posts: 1
Joined: Wed Nov 28, 2012 7:27 am
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby Akatsukami » Wed Nov 28, 2012 3:42 pm

And how is this different from doing a LOAD REPLACE?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1053
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post