we are using ODBC on Linux with SAPDB 7.4.03.27.
Do you mean search by google for 'ODBC and relative'
Thx in advance.
Albert
Daniel Dittmar schrieb:
Albert Steckenborn wrote:
with some sql statements, we get result tables with more that 10000 rows.
Is it possible to return only a segment of the result (i think so, because it it's possible in sqlstudio).
If it is, plz. show me a example statement.
This depends on the programming interface you're using.
- Precompiler: use FETCH RELATIVE and FETCH ABSOLUTE
- JDBC: use the methods relative () and absolute () of ResultSet
- ODBC: google for ODBC and relative
- Python: use the methods relative () and absolute () of SapDB_ResultSet
- others: will be based on ODBC and may or may not export this functionality.
With some interfaces, you'll have to create the cursor as scrollable.
Daniel Dittmar
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
