Iam reading data from sequential file. Data in sequential file is a comma delimited, final delimiter is end, double quoted. Issue here is one of the field contains value like this "1905 E COUNTY RD "D"". While reading data these records are getting dropped. Please help me out this problem its an urgent requirement.
Thanks in advance
did not consume entire input, at offset: 159
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the requirement is urgent, as you claim, sign up with your official support provider for priority service, and learn just how much "urgent" costs.
DSXchange is an all-volunteer site, whose members post as and when they can. Note also that they are under no compulsion to do so.
DSXchange is an all-volunteer site, whose members post as and when they can. Note also that they are under no compulsion to do so.
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.
No, it won't work using those suggestions. NVarChar and VarChar aren't relevant when it comes to sequential file quoting. And what "unique" has to do with this query is beyond me. Perhaps I have missed something and you could explain your suggestion in detail.nvdlrao wrote:Change the Data type to NVARCHAR followed by unique. It will work.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>