I have a file with below construct..
set schema abc
select field1, field2 from table xyz;
field1 field2
------ ------
100 abcd
101 abcd
111 mnop
3 record(s) selected
<EOF>
I have managed to use this file with removing first 3 and few bottom rows and just putting data in file manually.
Is there a way by which i can handle this in datastage itself.
Any help, suggestion would be much appreciated.
Thanks
Atul
Filtering top and bottom records from sequential file.
Moderators: chulett, rschirm, roy
Hi,
You could also use the filter command to be a sequential file's input and use a head and tail combination to do the same.
IHTH,
You could also use the filter command to be a sequential file's input and use a head and tail combination to do the same.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom