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
nareshbabu
Posts: 8
Joined: Tue Jun 17, 2008 6:26 pm
Skillset: cobol,jcl,vsam,db2,cics
Referer: friend

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.

User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am

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.

jayind
Posts: 62
Joined: Wed Apr 23, 2008 1:37 pm
Skillset: Mainframe - JCL, COBOL, VSAM, DB2, REXX, CICS
Referer: Internet Search
Location: Chennai, India
Contact:

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


  • Similar Topics
    Replies
    Views
    Last post