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
-- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
