|
View previous topic :: View next topic
|
| Author |
Message |
sripriya
New User
Joined: 19 Apr 2005
Posts: 26
|
|
|
|
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 |
|
 |
Ramya A
Active User
Joined: 26 Jul 2004
Posts: 104
|
|
|
|
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 |
|
|
|
|
