Header & Trailer Record Warning
Moderators: chulett, rschirm, roy
Header & Trailer Record Warning
Hi,
I get the following warning message when I try to read from the Source Sequential file "SEQ_Histpion,0: Delimiter for field "Field004" not found; input: {0d}, at offset: 107"
The reason is that the Header (and also Trailer) record do not have same metadata as all other data rows i.e. data rows have 28 cols where as these 2 (header & footer) have only 3 cols
How to do away with this warning.
Thanks,
NV
I get the following warning message when I try to read from the Source Sequential file "SEQ_Histpion,0: Delimiter for field "Field004" not found; input: {0d}, at offset: 107"
The reason is that the Header (and also Trailer) record do not have same metadata as all other data rows i.e. data rows have 28 cols where as these 2 (header & footer) have only 3 cols
How to do away with this warning.
Thanks,
NV
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
To ignore the header, check "First line contains column names" check box in 'output->format' tab.
I dont know how you can remove a trailor with datastage.
Sinc you are in unix, you can try removing them by using a filter command or writing a Script which can be called through "before job subroutine"
I dont know how you can remove a trailor with datastage.
Sinc you are in unix, you can try removing them by using a filter command or writing a Script which can be called through "before job subroutine"
-
- Participant
- Posts: 48
- Joined: Wed Jun 01, 2005 7:10 am
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Code: Select all
head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a rejects link from the Sequential File stage to capture the header and trailer row (as raw strings) into a separate data stream. You can process them separately or just ignore them.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.