Skip to Content
1

Does SAP HANA ODBC support scrollable cursors?

Sep 14, 2017 at 03:58 PM

51

avatar image
Former Member

None of these statement attributes seem to work:

  1. SQL_ATTR_CURSOR_TYPE + SQL_CURSOR_STATIC (accepted, but can only fetch forward)
  2. SQL_ATTR_CURSOR_SCROLLABLE + SQL_SCROLLABLE (error when setting the attribute)

So I assume scrollable cursors are NOT supported?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jeff Albion
Oct 11, 2017 at 05:48 PM
2

Hi Sebastien,

That is correct - HANA does not support scrollable cursors. We will add this information to our HANA Client Interface Programming Reference.

Best regards,

Jeff

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you Jeff.

We can emulate scrollable cursors, so it's not a blocker for us.

Seb

0