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.
Please check:
(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
END
The error that occurs:
"SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near ">": line 96 col 28 (at pos 5165)"
Thanks,
Anita.