Page 1 of 1
Fetch a specific record in File-Aid?
Posted: Fri Dec 27, 2013 12:37 pm
by Binamra
Hi,
Is ther any option in file-aid tool to fetch a specific record? This will help me as the file has million of records.
Thanks
Re: Fetch a specific record in File-Aid?
Posted: Mon Dec 30, 2013 2:38 am
by Robert Sample
Both batch and online File Aid have extensive record selection criteria. Either read the manual or use the online help facility.
Re: Fetch a specific record in File-Aid?
Posted: Thu Jan 02, 2014 4:35 pm
by Anuj Dhawan
If you're looking for a batch option, you can use the below Job for reference:
Code: Select all
//STEP001 EXEC PGM=FILEAID,REGION=4M
//SYSPRINT DD SYSOUT=*
//SYSLIST DD SYSOUT=*
----+----1----+----2----+----3----+----4---
//DD01 DD *
XXXX A AA
YYYY D BB
ZZZZ D MM
//DD01O DD SYSOUT=*
//SYSIN DD *
$$DD01 COPY IF=(1,EQ,C'XXXX,YYYY'),
AND=(30,EQ,C'AA,BB,CC'),OUT=0
/*
Output:
Re: Fetch a specific record in File-Aid?
Posted: Fri Mar 28, 2014 12:06 am
by Binamra
Thanks Anuj. This job helped.
Re: Fetch a specific record in File-Aid?
Posted: Fri Mar 28, 2014 12:50 am
by Anuj Dhawan
Glad, we had been helpful.