Skip to Content
0
Former Member
Apr 24, 2014 at 09:03 AM

Open Cursor of secondary HANA database with ADBC

245 Views

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