I would like to know if there is a way when unloading data from MS SQL with IBM Data Movement tool
that the XML data can be extracted to a seperata output file(s)/separating XML data from the other data.
So that the data can be loaded as follows:
db2 load .... xml from /xmlpath
How to overide the chardelimiter when doing the extract,because XML has "" which is chardelimier for the load,
and the load fails.
Thank you and regards
Pinned topic Export XML to different output Files
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-02-20T16:39:12Z at 2012-02-20T16:39:12Z by SystemAdmin
Re: Export XML to different output Files2012-02-20T16:39:12ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK
I am not quite familiar with c#.Is there no other way I could do it and then control it with the where clause
on the SELECT statement.