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
Fetch a specific record in File-Aid?
- Robert Sample
- Global Moderator
- Posts: 1885
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: Fetch a specific record in File-Aid?
Both batch and online File Aid have extensive record selection criteria. Either read the manual or use the online help facility.
- Anuj Dhawan
- Founder
- Posts: 2799
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Fetch a specific record in File-Aid?
If you're looking for a batch option, you can use the below Job for reference:
Output:
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
/*
Code: Select all
XXXX A AA
YYYY D BB
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
- Anuj Dhawan
- Founder
- Posts: 2799
- Joined: Sun Apr 21, 2013 7:40 pm
- Location: Mumbai, India
- Contact:
Re: Fetch a specific record in File-Aid?
Glad, we had been helpful.
Thanks,
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Anuj
Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute