Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2011
    Posts
    84

    Unanswered: xml derive column

    HTML Code:
      <user>
             <name>
                  <first>Han</first>
                  <initial>N</initial>
                   <last>cane</last>
              </name>
    
               <contactNO1>1236</contatctNo1>
                <contactNO2> 8956 </contatctNo2>
                <contactNO3>1487</contatctNo3>
         
              <address>canada</address>
    </user>
    
               

    Hi can you help me please on this...how can i display each contactno of all the user in separate column who's address ="canada"

    the format should like this
    Code:
    Name           cont1         cont2           cont3
    han             123            8956            1487
    Thank you in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Check the XMLTABLE function in the manual.

  3. #3
    Join Date
    Aug 2011
    Posts
    84
    Quote Originally Posted by n_i View Post
    Check the XMLTABLE function in the manual.

    Hi, can i ask favor to you can you give me some link...I don't where to find the xmltable manual...


    Kind Regards,

    Jemz

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by jemz View Post
    Hi, can i ask favor to you can you give me some link...I don't where to find the xmltable manual...
    Seriously. Have you heard of Google?

    IBM DB2 9.7 for Linux, UNIX and Windows Information Center

  5. #5
    Join Date
    Aug 2011
    Posts
    84
    Quote Originally Posted by n_i View Post
    Hi, thank you for the reply...Okay i thought that it could be found here the manual in dbforums...thank you again.i will write again if i have doubt.

Posting Permissions

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