Answer Detail: RE: How to retrieve las ten or first ten rows from a flatfile

GeekInterview.com > Tech FAQs > Data Warehousing

Print |

Question: How to retrieve las ten or first ten rows from a flatfile

May 05, 2008 08:59:56	#1
ambika shanmugam	Mainframe Expert Member Since: January 2007 Total Comments: 2
RE: How to retrieve las ten or first ten rows from a flatfile
Using the SORT operation, we can retrieve the set of records from the flat file Sample command; SORT FIELDS COPY STOPAFT=10 (stop after 10th record) SKIPREC=10 (skip first 10 records)