Fetch a specific record in File-Aid?

File-AID from Compuware and File Manager from IBM.
Post Reply
Binamra
Registered Member
Posts: 67
Joined: Mon Jun 17, 2013 10:42 pm

Fetch a specific record in File-Aid?

Post 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
User avatar
Robert Sample
Global Moderator
Global Moderator
Posts: 1885
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
United States of America

Re: Fetch a specific record in File-Aid?

Post by Robert Sample »

Both batch and online File Aid have extensive record selection criteria. Either read the manual or use the online help facility.
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: Fetch a specific record in File-Aid?

Post 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:

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.
Binamra
Registered Member
Posts: 67
Joined: Mon Jun 17, 2013 10:42 pm

Re: Fetch a specific record in File-Aid?

Post by Binamra »

Thanks Anuj. This job helped.
User avatar
Anuj Dhawan
Founder
Posts: 2799
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: Fetch a specific record in File-Aid?

Post by Anuj Dhawan »

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

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

Register

Sign in

Return to “File-AID and IBM File Manager.”