Hi

Using SQ 120.0 2483 trying LIMIT on select. Table was SA11 un-/reloaded into new SA 12 DB.

Trying to tun those two in ISQL

---
SELECT top 20 start at 10 *
FROM "DBA"."ticket"
order by ticket_id desc;

SELECT *
FROM "DBA"."ticket"
order by ticket_id desc
limit 10, 20;
---

in ALL variants of the second statements ISQL generates SQLCODE -131 on the line with limit regardless where the limit keyowrd is.

Either the help or the code is faulty.

Martin

The 12.0.0 help (in the SELECT statement syntax) reads

"The LIMIT keyword is disabled by default. Use the reserved_keywords
option to enable the LIMIT keyword. See reserved_keywords option. "

Did you enable the LIMIT keyword?

Glenn

Martin Baur wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

In article <4c3f2075$1@forums-1-dub>, you say...

Yes. But I forgot that I have to close ISQL first before I see the effect even if made permanent. After closing and reopening, it worked.

I was just exploring the new stuff of SA 12 in an ISQL window.

Thank you.