| View previous topic :: View next topic |
| Author |
Message |
Uttank
Beginner
Joined: 12 Feb 2004
Posts: 12
Topics: 9
|
 Posted: Sun Feb 15, 2004 6:17 am Post subject: UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD. |
 |
|
I deleted one row from a table in test env.And for the same record(row) I bought data from production env. for testing(in the form of punch and unload for 1 row.).When I tried to load this record I recieved this error msg "UNIQUE INDEX KEY DUPLICATES KEY OF INDEXED RECORD".
According to me, it seems that the record was not deleted from the index.
My question is,if this the case,how to delete the data from the index?
And the other question is, if we delete the entire table ,then I dont come across this error msg?In that case I believe the entire index gets deleted?
Can anybody pls explain with a solution..... |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Mon Feb 16, 2004 9:07 am Post subject: |
|
|
uttank,
How are you deleting the row from the table? Are you deleting via SPUFI or QMF? If you are then make sure that you have the AUTOCOMMIT set to YES. If it was set to NO then when your deletion of the record is rolled back.
You don't have to do any thing special to delete the index. If you physically delete a row with a commit then the index entry is automatically deleted.
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
