How to delete a record in ADM files

First, find out which data files/tables contain the record.

$searchit users1:[nuadm.files]*.dta "123456789"/out=judy.lis

$print judy.lis/que=admiss/form=hp12reg


******************************
USERS1:[NUADM.FILES]ADMACTIVITY.DTA;3

123456789 Fasasi Abiola muritala jr FB SP 1062003WEBAPP
123456789 Fasasi Abiola muritala jr TE SP 1062003WEBAPP
123456789 Fasasi Abiola muritala jr DE OR 1062003WEBAPP

******************************
USERS1:[NUADM.FILES]ADMDELAUDIT.DTA;1

123456789 Drew Hucks Drew Hucks Drew Hucks Drew Hucks Drew 9241 Vantine St 15235 Pittsburgh PA NE 4123715733 0 0123456789 6162000IN 6162000TMNS012S05142001ADM_CORY 07022003ADM_FLOY


******************************
USERS1:[NUADM.FILES]ADMLETTER.DTA;4

123456789 PRESLTR AP 01062003 1062003 01062003ADM_FLOY 01062003ADM_FLOY

******************************
USERS1:[NUADM.FILES]ADMMAIN.DTA;9

123456789I AP 1062003FINSA033SY 1Y 1 0 0 1062003PRESLTR 1062003WEBAPP 1062003WEB2APPL 200 999 fasasi23@yahoo.com 2N N 0 0 0 0 0 0 0 0 0 0 0 0 0 1 NN 1062003 mr oladayo fasasi my balogun tajudeen N


******************************
USERS1:[NUADM.FILES]ADMREQITEM.DTA;5

123456789 SCORE 01062003ADM_FLOY 01062003ADM_FLOY
123456789 HSTR 01062003ADM_FLOY 01062003ADM_FLOY
123456789 APPFEE 1062003 01062003ADM_FLOY 1062003WEBAPPL W

******************************
USERS1:[NUADM.FILES]DBCMAIN.DTA;24

123456789 Fasasi Abiola muritala jr Mr Abiola muritala Fasasi jr Abiola muritala Fasasi jr 12 evie street ojo road apapa a ajegunle lagos state nigeria 23401 Lagos OKNI 63 2348037124 123456789 0 lagos nigeria 1 1 NI 1062003WEBAPP 1062003WEB2APPL OT


******************************
USERS1:[NUADM.FILES]PARENT.DTA;2

123456789MMrs Fasasi Olawumi f Olawumi f Fasasi 12 evie street ojo road apapa ajegunle lagos state nigeria lagos 23401 trader 0 0 0 0 0 0

 

Then, delete the record in each file/table:

$ run dms:delete
DELETE V6.8-02 - Delete Data File Records 03:40 PM
Copyright (c) 2000, Campus America, Inc.
Data File Name <APPLICANT>? parent
Type "HELP" for assistance

Option? key

ID Number? 123456789
ID Number: 123456789
Fullname Alphabetical: Fasasi Abiola muritala jr
Parent-Guardian 1 Code: M
Parent-Guard 1 Title: Mrs
Parent-Guard 1 Last Name: Fasasi
Sure delete <NO>? y