Re: Is it possible to return segments of results
Daniel Dittmar <[email protected]> Sun, 14 Sep 2003 21:50:21 +0200
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Organization | SAP AG |
| Message-ID | <[email protected]> |
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 -- Daniel Dittmar SAP DB, SAP Labs Berlin [email protected] http://www.sapdb.org