Greater Than > in Hana?

[Former Member]

Context:

I have a Ms Sql Statement inside a xml file and I have a conditional with a "Greater Than" comparison, so because this within a XML File I can't use the regular syntax for "Greater Than" ( > ) then I use the (>)

Ms Sql Server Statement

<Query ID="some_query">

if ( DATEDIFF(day,@fechaVencimiento, getdate() ) &gt; 0  OR  @Consecutivo_Inicial &gt; @Consecutivo)
       begin
          set @Consecutivo= @Consecutivo_Inicial
          set @seReinicio = 2
       end

</Query>

Question:

What would be the equivalent syntax for ( > ) in Hana?

Thanks in advance.

Message was edited by: Tom Flanagan

[former_member182302]

Hi there,

Was '>' or '<' not working from XML? I used a > operator in a calculated column  and then exported the HANA model to see the XML file of it. It has something like this below:

<formula>IF(&quot;EMP NO &quot; >=3,&quot;EMPLOYEE NAME&quot;,&quot;GENDER&quot;)</formula>

Regards,

Krishna Tangudu

[Former Member]

Thanks Krishna Tangudu, I'll try that and let you know if it works for me!

Regards,

Rafael Reyes