SQLTeam.com | Weblogs | Forums

HANA Script


#1

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.