IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Question with respect to FILE-AID.


IBM Mainframe Forums -> Compuware & Other Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sripriya

New User


Joined: 19 Apr 2005
Posts: 26

PostPosted: Sat Dec 10, 2005 6:56 pm
Reply with quote

Hi all,

I have 500 records, using FILE-AID how can I get the output such that the first 100 records are skipped and from 101th record the alternate records are retrieved till 200th record.

Thanks in advance,
Sripriya.
Back to top
View user's profile Send private message
Ramya A

Active User


Joined: 26 Jul 2004
Posts: 104

PostPosted: Sat Dec 10, 2005 8:37 pm
Reply with quote

In fileaid browse option use the below parameters:

Selection criteria usage ===> T

In the next screen, use option 1

In the next screen, give

Code:
 Initial records to skip     ===> 100      then skip this many records     
                                                                             
   Subsequent Selection Interval:            then repeat the following       
     Records to select         ===> 1        - select this many records     
     Records to skip           ===> 0        - then skip this many records   
                                             until                           
   Number of records to search ===> ALL      you have read this many records
   Number of records to select ===> ALL      or selected this many records   
                                                                             
 SEQ/VSAM processing direction ===> F       (F = Forward; B = Backward)     

This will skip first 100 records and then select all the other records. A permutation combination of all the options will give you lot of other ways of selecting records.

Regards,
Ramya
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Compuware & Other Tools

 


Similar Topics
Topic Forum Replies
No new posts Selecting the max value from a file. DFSORT/ICETOOL 3
No new posts Change history of vsam file. JCL & VSAM 3
No new posts Split large FB file based on Key coun... DFSORT/ICETOOL 4
No new posts EMPTY file check scenario JCL & VSAM 6
No new posts SORT deletes the SORTOUT file DFSORT/ICETOOL 8
Search our Forums:

Back to Top