Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-02-20T16:39:12Z by SystemAdmin
SystemAdmin
SystemAdmin
708 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Export XML to different output Files

    ‏2012-02-20T14:41:35Z  in response to SystemAdmin
    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
      ACCEPTED ANSWER

      Re: Export XML to different output Files

      ‏2012-02-20T16:39:12Z  in response to SystemAdmin
      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