How search particular record by browsing in file aid...

In this Mainframe Forum - You can post your queries on FILE-AID tool

Moderators: Anuj Dhawan, Moderator Group

Post Reply
c4shiva
Member
Posts: 1
Joined: Thu Nov 28, 2013 3:03 pm

How search particular record by browsing in file aid...

Post by c4shiva » Thu Nov 28, 2013 3:28 pm

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 :)
Regards,

Shiva

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Thu Nov 28, 2013 4:09 pm

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?
Regards
Nic

devegouda.chage
Member
Posts: 32
Joined: Mon Sep 12, 2011 10:50 am
Location: Bangalore

Re: How search particular record by browsing in file aid...

Post by devegouda.chage » Fri Nov 29, 2013 2:37 pm

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.
Thanks & Regards
Dev

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Dec 03, 2013 1:44 am

All of the records will still have to be read and bypassed . . .
Have a good one

devegouda.chage
Member
Posts: 32
Joined: Mon Sep 12, 2011 10:50 am
Location: Bangalore

Post by devegouda.chage » Tue Dec 03, 2013 10:03 am

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?? :roll:
Thanks & Regards
Dev

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Tue Dec 03, 2013 3:01 pm

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.
Regards
Nic

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Dec 03, 2013 10:48 pm

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.
Have a good one

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others