6 Replies Latest reply: Jun 4, 2012 5:36 AM by Rajasekhar Kota RSS

    Column value as identifier in XMLELEMENTmethod

    Rajasekhar Kota Newbie

      Hi,

       

      We are using Teiid 7.7. I have a concern on SQL / XML.

       

      I have a SQL as Select A.c1,A.c2,A.c3 from tab as A and the value of c2 will be the same for all the rows.

       

      I want to convert the values of the columns to XML. Also I want to retrieve the identifier value from the column's value

       

      Can I write the SQL as follows where the identifier name is the c1's column value.

       

      Select A.c2, xmlelement(A.c1, XMLATTRIBUTES(convert(A.C3, String) as "SYSID")) from tab as A

       

      We tried using this but there was a syntax error.

       

      Is there any way to achive this using any other method?

       

      Thanks

      Raj