Limit offset

[Former Member]

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.

[Former Member]

any Help please? thanks alot