Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Smile Unanswered: How to locate the row given rowid (os390)


    After running CHECK, I get the rowid's of the table. How can I see the exact row in question ?

    Eg : RID of existing row is X'00000000802' , How to get to the exact row of this table ?


  2. #2
    Join Date
    Apr 2004


    I am not sure if it is possible to locate the row using rowid that easily. I had similar problem sometime back and posted a thread here. Besides Rowids are present in the index.

    One way is unload the whole table and then load replace with a DISCARD DD card with enforce yes. You will get all the bad records there in DISCARD file. And can decide what to do with them and change them if needed and reload this corrected bunch with load resume.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts