View previous topic :: View next topic
|
Author |
Message |
friend_prasad
New User
Joined: 06 Jan 2006 Posts: 12
|
|
|
|
I HAVE 2 IDENTICAL ROWS IN DB2
FROM THAT I WANT TO DELETE ONLY A SINGLE ROW CAN ANYBODY TELL ME HOW TO DELETE A PARTICULAR ROW FROM THAT
THANKS |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
Back to top |
|
|
T-REXDB2
New User
Joined: 28 Apr 2005 Posts: 11 Location: USA
|
|
|
|
friend_prasad wrote: |
I HAVE 2 IDENTICAL ROWS IN DB2
FROM THAT I WANT TO DELETE ONLY A SINGLE ROW CAN ANYBODY TELL ME HOW TO DELETE A PARTICULAR ROW FROM THAT
THANKS |
Simply utilize the REPAIR utility to DELETE the offending RID!
Example - Remove nonindexed row found by BMCREORG+ (OEM 3rd party non-IBM tool): Given - when reorganizing space DBNAME.SPC1, the following message was encountered:
DSNU3401 DSNURBXA - ERROR LOADING INDEX, DUPLICATE KEY
INDEX = SPC1IX1
TABLE = TAB1
RID OF INDEXED ROW = X'00000888'
RID OF NONINDEXED ROW = X'00000501'
Resolution: Simply delete the nonindexed row, via REPAIR utility, executed in native JCL stream (FYI DELETE it is logged by default - LOG keyword not mandatory!).
REPAIR
LOCATE TABLESPACE DBNAME.SPC1 RID (X'00000501')
DELETE
Hope this helps, muchly!!! ;-] |
|
Back to top |
|
|
|