I'm almost embarrassed to ask this question, since it seems so simple, but here goes...
I'm attempting to read the entire contents of a row from a sequential stage into a single column. The rows within the source file have varying lengths and may contain any ASCII value. I've defined a single column in my sequential file stage, and I've tried specifying a variety of delimiters (including 000), but in each case at least one row in the data appears to contain the delimiter value and throws up a "too many columns in record" error.
Any suggestions?
Thanks!
Peter
Reading an entire row from sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Reading an entire row from sequential file
If the line terminator can be part of the data and is not quoted you really have no means of determining what a "line" consists of. In case like this you usually parse the data in the job according to some other rules, so I've found it best to arbitrarily set a fixed width column with no terminators of any sort, and then modify the data myself in the job.patonp wrote:...The rows within the source file have varying lengths and may contain any ASCII value...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>