Re: Is it possible to return segments of results

Hi,

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
>