Hi all,
I have a comma delimited file for which i had defined the schema file .But for one of the column i am getting comma in the value for one of the file.How should i define this property in schema file.
question 2
I wanted to know if we can mention "First Line is Column Names=FALSE/TRUE" in the schema file
Thanks in advance .
schema file layout
Moderators: chulett, rschirm, roy
schema file layout
thanks n regards
nani
nani
I am afraid that I don't quite follow the first question, but unfortunately the schema does not contain information on whether or not the first line contains the column names, therefore there is no way to set this in a schema file.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The parallel Sequential File stage is intolerant of field delimiters occurring within fields, even if they're quoted.
Best workaround is to use a server Sequential File stage within a server Shared Container in your parallel job.
Best workaround is to use a server Sequential File stage within a server Shared Container in your parallel job.
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.