Results 1 to 8 of 8

Thread: XML on db2 9

  1. #1
    Join Date
    Sep 2006
    Posts
    6

    Unanswered: XML on db2 9

    guys pls help me out here i wanna know can i put xml file as a whole into db2 9 and then retrieve data or manipulate or access it via the database ,....
    thank u...

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    xml

    Yes, you can. db2 V9 has complete support for xml data type
    see developersworks fro many articles/tutorials about xml select/updates...
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Sep 2006
    Posts
    6
    hey dude i tried the import command but its still does not get the data in my xml file into the database ......

  4. #4
    Join Date
    Sep 2006
    Posts
    6
    Quote Originally Posted by przytula_guy
    Yes, you can. db2 V9 has complete support for xml data type
    see developersworks fro many articles/tutorials about xml select/updates...
    shuld i be using the xml extender

  5. #5
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96
    No, you can import it directly, you can read it in the docs.

    Kind regards, Gert

  6. #6
    Join Date
    Sep 2006
    Posts
    6

    it does not work

    dude i want to import the xml file directly .... in that method we have to first export it and then import it.....i want to import the xml file directly in my table.....can only exported data be imported.....
    Last edited by xzander; 09-22-06 at 06:57.

  7. #7
    Join Date
    Jun 2006
    Posts
    471

    import

    in the delimited input file for the xml column you specify the file name
    11,"xxxxx","xml filename"
    db2 import from delfile of del modified by lobsinfile insert into...
    this will bring in the external file
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  8. #8
    Join Date
    Sep 2006
    Posts
    6
    thank u maan this works .... but this is not at all application friendly.....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •