With BMC load can we update an existing record

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

With BMC load can we update an existing record in the table. Will the new value im passing will get updated?

When i trying to update some records, the records whihc im trying to pass is going into error file as duplicate.

Gnanas N · Posted: Tue Mar 24, 2009 8:40 pm

Please post your control cards here.

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

LOAD DATA
REPLACE ( Instead of this Replace If i give RESUME YES - Can i update the records)
LOG NO
CHECKPEND NO
UPDATEDB2STATS YES
ENUMROWS (,150000)
INTO TABLE PABC0.ABCDE

(AAA_name POSITION(1:4) INTEGER
,BBB_dob POSITION(5:5) CHAR(1)

)

dick scherrer · Posted: Wed Mar 25, 2009 9:53 am

Hello,

If some of the columns/keys are defined as unique any update that causes a duplicate condition will be prevented.

Somewhere in the process the value ablut to be used to update must be checked to see if it already exists.

This same consideration should be checked for the condition wiere 2 of the "new" values are duplicates. They don't duplicate any existing values, but they might duplicate each other fro the new population..

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

My understanding was like BMCLOAD utility is only for loading or unloading. But it was like we can even update an existing record with the help of BMCLOAD. Is my understanding correct?

If we can update a record with BMCLOAD can you please tell me what is the specific keyword we need to inclulde in the CNTL card for updating. I thought it was RESUME.