Data from source is as follows.
a||metaway"insurance||b||c
When i am creating a sequential file of above data in server by specifying option quite character values as " data loks like below.
a||"metaway"insurance"||b||c
Sequntial File Format in Server Edition:
Delimiter=|
Quote Character="
but in parallel edition the extra quotes were not inserted and hence it was rejected while loading to table.
a||metaway"insurance||b||c
Sequntial File Format in Parallel Edition:
Pipe delimited
Null Filed Value=""
Quote="
How would we handle in parallel edition when these characters appears.
Thanks
Sequential File creation in parallel and Server
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Unfortunately, that's "the way things are". The parallel Sequential File stage is notorious for not handling embedded quote characters properly, as a Search through this forum will reveal. You can, of course, put your own quotes on and specify the Quote Character property as none, but it would have been so much nicer if the stages behaved the same way.
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.