Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: XML format of records in db2 tables

    Do we have a function or any tool to convert records of a table in DB2 into XML format?

    TIA

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: XML format of records in db2 tables

    XML Extender

    On V8, it is packaged with the database ..

    In earlier versions, you will find this on a seperate CD



    Cheers
    Sathyaram


    Originally posted by ggnanaraj
    Do we have a function or any tool to convert records of a table in DB2 into XML format?

    TIA
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Hi

    Thanks for the input.

    Would you be able to give the steps to get the XML format of all records in a table?

    I'm looking for something like... for eg., to spool the following query to a file...assumming that there is a xml function...any pointers should be helpful.

    Code:
    select xml(empno, empname) from emp
    TIA.
    Last edited by ggnanaraj; 11-08-03 at 00:46.

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I'd suggest that you visit the IBM website and read a user-guide to understand what can be done and cannot ...

    Cheers
    Sathyaram


    Originally posted by ggnanaraj
    Hi

    Thanks for the input.

    Would you be able to give the steps to get the XML format of all records in a table?

    I'm looking for something like... for eg., to spool the following query to a file...assumming that there is a xml function...any pointers should be helpful.

    Code:
    select xml(empno, empname) from emp
    TIA.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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