xml derive column

jemz · #1 (**permalink**) 09-28-11, 14:36

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

n_i · #2 (**permalink**) 09-28-11, 14:44

Check the XMLTABLE function in the manual.

jemz · #3 (**permalink**) 09-29-11, 07:13

Quote:

Originally Posted by n_i

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

n_i · #4 (**permalink**) 09-29-11, 08:33

Quote:

Originally Posted by jemz

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

jemz · #5 (**permalink**) 09-29-11, 11:16

Quote:

Originally Posted by n_i

Seriously. Have you heard of Google?

IBM DB2 9.7 for Linux, UNIX and Windows Information Center

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech