Update DB2 table using any utility
Posted: Fri Dec 02, 2011 11:17 pm
Hi all,
I have a requirement that I need to update the database once I get the feed, but the key fields will be inserted by another job. Based on the key fields i need to update other few column detail since those values are available in the file only.
Is there any utility which will update the values in the table. Also please suggest me how this can be done through re-org the database and then load the database.
I can do COBOL change for this - But This involves lot of changes, so dropped this suggestion.
Any help would be great.
Best Regards,
Harikrishnan
I have a requirement that I need to update the database once I get the feed, but the key fields will be inserted by another job. Based on the key fields i need to update other few column detail since those values are available in the file only.
Is there any utility which will update the values in the table. Also please suggest me how this can be done through re-org the database and then load the database.
I can do COBOL change for this - But This involves lot of changes, so dropped this suggestion.
Any help would be great.
Best Regards,
Harikrishnan