View previous topic :: View next topic
|
Author |
Message |
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. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Please post your control cards here. |
|
Back to top |
|
|
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)
) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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.. |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
|