How to fetch a particular record in File-Aid.



Compuware's data management products: File-AID for IMS, File-AID/MVS, File-AID for DB2 and DBA-XPERT for DB2

How to fetch a particular record in File-Aid.

Postby nareshbabu » Thu Jun 26, 2008 5:01 pm

what is the option in file-aid tool to fetch a particular record when a file contains million of records.

thanks in advance,
naresh.
nareshbabu
 
Posts: 8
Joined: Tue Jun 17, 2008 6:26 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to fetch a particular record in File-Aid.

Postby dick scherrer » Fri Jun 27, 2008 12:46 am

Hello naresh and welcome to the forums,

Possibly a better approach would be to process the file in batch using your sort product and copy only some few (or a single) record(s) to a new file. This new "selected" file would be far more efficient to use online.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: How to fetch a particular record in File-Aid.

Postby jayind » Fri Jun 27, 2008 1:24 pm

Hello Naresh,

In addition to what dick mentioned and a little explanatory way,

I dont know whether you have noticed that, FILEAID has batch processing option also. If you want to read a particular record you can give the key value or search using a value and submit it in batch process using the option available in FILEAID. it will create a JCL for you and the output can be captured either in the spool or mention an output dataset name.

Hope this helps...
jayind
 
Posts: 62
Joined: Wed Apr 23, 2008 1:37 pm
Location: Chennai, India
Has thanked: 0 time
Been thanked: 0 time


Return to File-AID

 


  • Related topics
    Replies
    Views
    Last post