Page 1 of 1

How to fetch a particular record in File-Aid.

PostPosted: Thu Jun 26, 2008 5:01 pm
by nareshbabu
what is the option in file-aid tool to fetch a particular record when a file contains million of records.

thanks in advance,
naresh.

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

PostPosted: Fri Jun 27, 2008 12:46 am
by dick scherrer
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.

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

PostPosted: Fri Jun 27, 2008 1:24 pm
by jayind
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...