Topic
  • 2 replies
  • Latest Post - ‏2012-02-20T16:39:12Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts

Pinned topic Export XML to different output Files

‏2012-02-20T09:15:43Z |
Hi,

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

or

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
Martin
Updated on 2012-02-20T16:39:12Z at 2012-02-20T16:39:12Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: Export XML to different output Files

    ‏2012-02-20T14:41:35Z  
    would you be willing to write a short program in c# that does that for you?
    this way you can exactly control the logic
  • SystemAdmin
    SystemAdmin
    708 Posts

    Re: Export XML to different output Files

    ‏2012-02-20T16:39:12Z  
    would you be willing to write a short program in c# that does that for you?
    this way you can exactly control the logic
    Hi,

    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.

    Thanks
    Martin