Stopaft - Help!.

Main Menu Computer Tips Software Downloads Menu

Main Question - Posted From Guest:
As you say in your post STOPAFT allow you to stop processiong after 10 rows, so de top 10 would be copied, but is it possible to obtain the last 10 rows with something similar? Thank you!!

Guest Says:
You can use the skiprec option to go past the first X number of rows if you know how many rows are in your file. For example OPTION SKIPREC=51000 will bypass the first 51000 rows. You could also just sort them in reverse order and then use stopaft, depends upon your business need.

Frank Yaeger Says:
You can use the SUBSET operator of DFSORT's ICETOOL to keep the last 10 records like this:

SUBSET FROM(IN) TO(OUT) INPUT KEEP LAST(10)

For complete details on the SUBSET operator, see:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/7.17?DT=20100630155256

Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Add your reply below ...

This site allows you to ask questions and get answers from various posters, you may also answer any posts if you feel like you have input to give. Feel free to ask for help with any new question you wish, but most of the questions here are tech related. You will find many questions and answers related to your Ipod or Ipod Nano, Itunes, audio and video converting, spyware or adware cleanup, pc or other computer questions, and even mainframe questions. Although these are the tech questions most often asked, you will find help on almost any computer or software related subject. Feel free to go to the main menu and review the posts already present, or feel free to ask your own question. (Some questions will be closed once the moderator feels they are sufficiently answered and that no other input is needed).