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
- 30978 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shar
Well if must use filter option in sequential stage then
the Ans is:
head -n 10 'FileName' | tail -n 8
explanation:
suppose if ur file has 10 records + column name then total
lines are 11.
col1
1
2
3
4
5
6
7
8
9
10
head -n 10 will fetch column name + 9 records
and
tail -n 8 will fetch 2 to 9 records excluding colname and
1st record.
like :
2
3
4
5
6
7
8
9
Thats it.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
EXPLAIN SCD
how to write server Routine coding?
What is the use of datastage designer?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Define Data Stage?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What is the difference between in process and inter process?
How to read multiple files using a single datastage job if files have the same metadata?
What are the types of views in datastage director?
how do u catch bad rows from OCI stage? And what CLI stands for?
what are the devoleper roles in real time? plz tell i am new to datastage....
Differentiate between datastage and datastage tx?
Different ways a project can be moved to production ?...example ….export-import and Version control.
