IBM Mainframe Forum

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

thanks in advance,
naresh.

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.

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