Interested to Buy Any Domain ? << Click Here >> for more details...
How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use
- 6 Answers
- 30964 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / msbharathi
In sequential file stage use the filter in the options
In filter use sed '1d;$d'
You can use sed '<start>,<end>d' to delete particular rows and use sed -n '<start>,<end>p' to keep particular rows
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between in process and inter process?
Why do you need stage variables?
What are the types of containers and how to create them?
What are the components of ascential data stage?
What are the partitioning techniques available in link partitioner?
Differentiate between Join, Merge and Lookup stage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the functionalities of link partitioner?
How do you register plug-ins?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What is the difference between orabulk and bcp stages?
How to Remove Duplicate using SQL?
Is the value of staging variable stored temporarily or permanently?
how can we create rank using datastage?what is the meaning of rank?
how to abort the job its matain duplicates?
