Home > IT Answers > AS/400 > DB2/400 delete record
pdsathishkumar
3,740 pts.
 DB2/400 delete record
DB2/400
how to delete record using UPDDTA command...

Software/Hardware used:
as400 v5r3
ASKED: November 27, 2011  5:46 AM
UPDATED: February 28, 2012  3:11 PM
RELATED QUESTIONS
Answer Wiki:
Using UPDDTA, you can delete records. Give like this, UPDDTA filename Now Press PageDown key, you can see the PF Records one by one. Then go to the specific Record and Press <b>Shift+F11(that is F23)</b>, it will ask for conformation and do it again to Delete. Using this you can delete only one record at a time. Surey...
Last Wiki Answer Submitted:  November 27, 2011  5:59 am  by  Sureyz   1,730 pts.
All Answer Wiki Contributors:  Sureyz   1,730 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Interesting. F23=Delete a record isn’t listed in the screen footer, but is listed in the Function Keys – Help – as are a couple of other function keys not shown.

Splat
 5,720 pts.
 

I never thought of deleting using UPDDTA but F23 really works.
Thanks guys

ITKBHARAT
 120 pts.