Hi,
I reading data from tables & writing to a sequential file.Each time I am running I am overwriting the existing files.
I had been running the jobs for several times.I have checked "First Line is Column Names" always.I have never got this problem before.
But only during incremental load,there is duplicate header record being created in the file.That is even the second row in the file is a Header Record.
Can anyone please help me?
Thanks
Duplicate Headers
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you read the file without "first line is column headings" checked, then the first row will be regarded as data. If you then write a file with column headings checked, the header is written, then the first row of data that you read (a header again) is also written, then the remaining data rows are written.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
hello your mentioned problem occurs only during incremental load where you append data to existing file without checking a box of "First line is column names".
please tick the check box "First line is column names" for your incremental load and also have a look on your created file externally with vi editior.
please tick the check box "First line is column names" for your incremental load and also have a look on your created file externally with vi editior.