Does SAP HANA ODBC support scrollable cursors?

[sebflaesch]

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?

[jeff_albion · Accepted solution]

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

[sebflaesch · Accepted solution]

Thank you Jeff.

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

Seb