Fetch a specific record in File-Aid?

File-AID from Compuware and File Manager from IBM.
Previous topicNext topic

Topic Author
Binamra
Registered Member
Posts: 41
Joined: Mon Jun 17, 2013 10:42 pm
Zodiac: Sagittarius

Fetch a specific record in File-Aid?

Post by Binamra » Fri Dec 27, 2013 12:37 pm

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: 1379
Joined: Fri Jun 28, 2013 1:22 am
Location: Dubuque Iowa
Zodiac: Virgo

Re: Fetch a specific record in File-Aid?

Post by Robert Sample » Mon Dec 30, 2013 2:38 am

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: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Fetch a specific record in File-Aid?

Post by Anuj Dhawan » Thu Jan 02, 2014 4:35 pm

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.


Topic Author
Binamra
Registered Member
Posts: 41
Joined: Mon Jun 17, 2013 10:42 pm
Zodiac: Sagittarius

Re: Fetch a specific record in File-Aid?

Post by Binamra » Fri Mar 28, 2014 12:06 am

Thanks Anuj. This job helped.



User avatar

Anuj Dhawan
Founder
Posts: 2624
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Zodiac: Sagittarius

Re: Fetch a specific record in File-Aid?

Post by Anuj Dhawan » Fri Mar 28, 2014 12:50 am

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.

Previous topicNext topic

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