Question Re: Limit offset in Technology Q&A

Limit offset

Former Member — Fri, 12 Jul 2013 11:17:15 GMT

Hello,

I am trying to fetch rows from MaxDB with limit and offset. However, I cannot use the offset syntax found at http://help.sap.com/saphelp_erp60_sp/helpdata/de/40/1312152fa511d3a98100a0c9449261/content.htm.

I am able to fetch e.g. result 1 to 15 by using "limit 15", but if I try to get result 15 to 30 by using "limit 15,15" i get the following error:

"Error Executing 'Processing result rows' SAP DBTech JDBC: [-7085]: Function not allowed for this cursor.[-7085]: Function not allowed for this cursor"

Could my SQL syntax contain errors, or does MaxDB not support the use of offset with the limit clause?

My MaxDB Version is 7.6.06.03.

Re: Limit offset

Former Member — Mon, 15 Jul 2013 11:37:11 GMT

any Help please? thanks alot

Re: Limit offset

Former Member — Mon, 15 Jul 2013 16:05:31 GMT

Hi,

the LIMIT clause with offset works only with 'forward only cursor'.

To switch to forward only cursor in Databbase Studio select

Windows->Preferences->Database Studio->Query Results

and enable the "Use forward only result cursor" Checkbox.

Kind regards,

Re: Limit offset

Former Member — Mon, 15 Jul 2013 21:07:35 GMT

Hi Burkhard,

Thank you for helping me once again, you help is always much appreciated.

unfortunately i was misunderstood.

I am asking about Limit with offfset in SQL statment, since i am selecting huge Data for the website, i would like to trancute it into parts which makes the results faster for the website.

thanks alot

regards

Re: Limit offset

Former Member — Tue, 16 Jul 2013 09:00:47 GMT

Hi,
the error message you have posted comes from JDBC or Database Studio so I guess you have change the Interface 😉

I am sorry the cursor modeI in MaxDB PHP is always SCROLL_SENSITIVE.

We need scrollable cursor for PHP data_seek function. Try it with data_seek and pass the offset.

Regards,

Re: Limit offset

Former Member — Tue, 23 Jul 2013 14:34:10 GMT

Hi Burkhard,

unfortunately this Data_seek is only like a pointer, but the result were already in bulk selected, and our Gaol is to get the result themself in steps and not all at once

is there no other function in MaxDB? no limit 10,10 ...etc.

thank you very much

regards,