Page 1 of 1
How search particular record by browsing in file aid...
Posted: Thu Nov 28, 2013 3:28 pm
by c4shiva
Hi
Can any one help me hz to find a particular record in file aid. i browsed the file and in command line i tped F XXXXXX , but it started to read all recs... it take more time as file having more than a 2lak records is any other way to find a particular recs... pls help. Thanks
Posted: Thu Nov 28, 2013 4:09 pm
by NicC
Unless you have an indexed file how do you expect File Aid to find your record without reading all the records before the one you want?
Re: How search particular record by browsing in file aid...
Posted: Fri Nov 29, 2013 2:37 pm
by devegouda.chage
c4shiva wrote:Hi
is any other way to find a particular recs...
I Think you can use Quick option in Selection Cretiria.
in which you need to specify the position of the field ,length of the field and the value you want to search.
Posted: Tue Dec 03, 2013 1:44 am
by DikDude
All of the records will still have to be read and bypassed . . .
Posted: Tue Dec 03, 2013 10:03 am
by devegouda.chage
DikDude wrote:All of the records will still have to be read and bypassed . . .
OH!!!
I did not know this!!!
Thanks for the correction DikDude.
but,this method is bit faster than FIND command is it so??
Posted: Tue Dec 03, 2013 3:01 pm
by NicC
I shouldn't think so - all records up to the one you want still have to be read because you do not know which one is the one you want - it could be the first it could be the last. If the file is keyed then you can search by key.
Posted: Tue Dec 03, 2013 10:48 pm
by DikDude
but,this method is bit faster than FIND command is it so??
Lik NicC, i dont believe so.
Suggest you create a Very large test file and try both ways.
Suggest you run both in batch so there will be footprints to follow.