Skip to Content
0
Former Member
Apr 29, 2014 at 10:42 AM

Use of Cursors in HANA SQLScript

1496 Views

Hello Experts,

I have a scenario where I need to use 2 cursors and the cursor declaration is done in a different Begin-End block and the cursor is being accessed in a

different Begin-End.How can we achieve that in SQLScript and also Can we have a result set in the for loop like

example

FOR a in(select from some table) Loop

some dml statments

ENDFOR

Is such type of statment allowed or are there any other alternative availabe?

Please guide on the same.

Thanks in advance.

Manisha