Home > IT Answers > New record on the deleted record’s space?
RamvishakRamesh
1,975 pts.
 New record on the deleted record’s space?
Delete
Suppose I have 100 records and I have deleted the 50th record and now I have added a new record, I want that to be on the 50th position. How?

Software/Hardware used:
ASKED: May 29, 2012  11:17 AM
UPDATED: May 31, 2012  12:34 AM
RELATED QUESTIONS
Answer Wiki:
If you are using REUSEDLT(*YES), it might use that space. You are better off creating an index for the sequence that you need.
Last Wiki Answer Submitted:  May 29, 2012  12:24 pm  by  CharlieBrowne   32,915 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,915 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You could process it as a direct (relative) file and write the record to record number 50. But CharlieBrowne is right — you are better off creating an index for the sequence that you need.

Tom

TomLiotta
 108,260 pts.
 

We’re assuming that this is a DB2 AS/400 question.

philpl1jb
 44,190 pts.