Can we use Load options together

sravz chinnu · New User Joined: 07 Dec 2011 Posts: 26 Location: India

Hi All,

Can we use Load options
RESUME YES
REPLACE

together.

I want to replace the rows in DB2 with the updated rows in the flat file.

I am using utility to do LOAD process.

Please let me know this.

Sravani

Pandora-Box · Posted: Thu Apr 05, 2012 11:24 am

Is that you wanted updated selected records in table using updated records in file?

You cant make use of load utility directly

If size of the table is less unload it and compare with records in the file and create a fresh load file which needs to be present in the table and use LOAD replace

Or Compare the files and just check for the updated data and use programmatic method to update the table

Or Use Programmatic method to read and update the table ( If file has fewer records)

Or You can explain better about your requirement

sravz chinnu · New User Joined: 07 Dec 2011 Posts: 26 Location: India

Prem,

My requirement is to load new inserts and updates in to the existing table from flat file.

I will have two diffenrent files for inserts aswell as updates. Inserts i am able to do with Resume yes option in LOAD.

Wheni am doing REPLACE option the complete data is being replaced with this new data and losing the old data.

UNLOAD and COMPAring the files may not work inmy case because i have some millions of data.

Please suggest if i can do this any other way.

Pandora-Box · Posted: Thu Apr 05, 2012 11:50 am

What is the size of the data do you expect in insert and update file?

sravz chinnu · New User Joined: 07 Dec 2011 Posts: 26 Location: India

sushanth bobby · Posted: Fri Apr 06, 2012 10:34 pm

Hi Sravz,

What you can do is ?
Split INSERT and UPDATE records into separate files, if possible.
Load the insert and Write a program to read the update file and update it in DB2.

or

Do a combo using MERGE statement ?

Thanks,
Sushanth

dick scherrer · Posted: Sat Apr 07, 2012 12:00 am

Hi Bobby,

Good to "see" you've returned

d

sushanth bobby · Posted: Mon Apr 09, 2012 8:44 am

Thanks d.sch.