HI. I'm trying to convert a TSQL to a HANA Script.
I don't know if you can help me.
I'm having an error that i just can't see what i'm supposed to do.
(this is a part of my procedure)
IF RECON = 'N' THEN BEGIN DECLARE CURSOR cCursor FOR SELECT "TransId", "CD" FROM #Temp Order By "DataLancamento", "TransID"; -- OPEN cCursor; WHILE 1 = 1 DO BEGIN FETCH cCursor INTO TransID, Value; --FOR FETCH_STATUS NOT IN 0 DO --BREAK; FOR Counter AS "0" DO SaldoAcumulado = Value; FOR Counter > "0" DO SaldoAcumulado = (SaldoAcumulado + Value); UPDATE #Temp SET [Saldo Acumulado] = @SaldoAcumulado WHERE TransId = @TransID SET @Counter += 1; END WHILE; CLOSE cCursor; DEALLOCATE cCursor; SELECT * from #Temp Order By [DataLançamento], TransId
The error that occurs:
"SAP DBTech JDBC: : sql syntax error: incorrect syntax near ">": line 96 col 28 (at pos 5165)"