Hi HANA-experts,
I need help to change an open cursor of the primary database to an open cursor of the secondary HANA database with ADBC. The open cursor of the primary database is the following:
OPEN CURSOR cursor FOR
SELECT fieldname1 fieldname2
FROM viewname
WHERE fieldname IN rangetab.
DO
FETCH NEXT CURSOR cursor
INTO CORRESPONDING FIELDS OF TABLE interntab
PACKAGE SIZE cursor_size.
IF sy-subrc <> 0.
EXIT.
ELSE.
"todo
ENDIF.
ENDDO.
CLOSE CURSOR: cursor.
I have defined the view in HANA Studio. I want to call this view with an open cursor in ERP. I need now a SELECT with cursor using ADBC. Can you give me the best way to solve it?
Thx, mlf