Skip to Content
0
May 29, 2020 at 12:48 PM

Cursor in HANA

441 Views

Hi All,

I need to migrate a query similar to the below mentioned one from SQL to HANA. can somebody advice on this topic?

DECLARE @Anexo NVARCHAR(1)

DECLARE @PN NVARCHAR(15)

DECLARE @Total NUMERIC(19,6)

CREATE TABLE #tabela ( Anexo NVARCHAR(1), PN NVARCHAR(15), Total NUMERIC(19,6))

DECLARE c1 CURSOR FOR

Select 'A', CardCode, DocTotal from OPCH

OPEN c1

FETCH NEXT FROM c1 INTO @Anexo, @PN, @Total

WHILE @@fetch_status <> -1

BEGIN INSERT INTO #tabela(Anexo, PN, Total)

VALUES (@Anexo, @PN, @Total)

FETCH NEXT FROM c1 INTO @Anexo, @PN,@Total

END

CLOSE c1

DEALLOCATE c1

select Anexo, PN, sum(Total) AS Total from #tabela

Group By Anexo, PN

DROP TABLE #tabela

Thanks!