Search code examples
sql-serverxmlhana

Greater than operator in Hana

I have a sql query inside a XML File and I need to use the comparision operator GREATER THAN but with this syntax "&gt" The sql conversor I'm using from Ms Sql Server to HANA displays an error with &gt

Question: Does Hana support &gt operator?

because I have the sql query inside a xml file I CAN'T USE the > syntax because > is closing sign for XML syntax instead I have to use &gt

Thanks in advance.

Solution

  • You may be able to solve your problem by making use of cdata sections in your XML document. In particular, you would want to wrap your queries in cdata sections. For example:

    <root>
    <query>
    <![CDATA[
    select vbeln from vbpa where posnr > 50.
    ]]>
    </query>
</root>

    For more about cdata sections refer to this question: What does <![CDATA[]]> in XML mean?