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

Questions by amar_smmath   answers by amar_smmath

Showing Answers 1 - 2 of 2 Answers

ambika shanmugam

  • May 20th, 2008
 

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)
 

  Was this answer useful?  Yes

Praful

  • Dec 17th, 2012
 

In datastage, we can use the External Filter stage, use the unix command head or tail to retrieve the particular lines from the flat file.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions