SAP Knowledge Base Article - Preview

2512773 - SELECT fails with row limitation clause LIMIT - SAP IQ


SELECT fails with row limitation clause LIMIT with error:

Could not execute statement.
Syntax error near 'LIMIT' on line 4
SQLCODE=-131, ODBC 3 State="42000"
Line 1, column 1

Although the syntax with LIMIT or LIMIT OFFSET is allowed:

row-limitation-option-2 :
LIMIT { [ offset-expression, ] limit-expression | limit-expression OFFSET offset-expression }



  • SAP IQ 16
  • SAP SQL Anywhere 16
  • SAP SQL Anywhere 17


SAP NetWeaver 7.5


CR# 809982 ; 809982 ; OFFSET , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.