SAP Knowledge Base Article - Preview

2316016 - iqunload returns a syntax error near 'limit'.

Symptom

iqunload utility gives a syntax error below.
  
 [hpita:/home1/DBA] iqunload -c "uid=dba;pwd=sql;eng=IBM" -n -o tab_1.log -r tab_1.sql -ul 'TAB_1' -v -y .
 SAP IQ Unload Utility Version 16.0.0.2014
 Connecting and initializing
 Error in file unload.sql at line 865 with sqlcode -131
 ***** SQL error: Syntax error near 'limit' on line 81

This error happens because a database option RESERVED_KEYWORDS is set to 'LIMIT'.
It is to specify 'LIMIT' clause in queries like 'select ... from ... order by ... LIMIT 0,500;'.
If the option is set to the default value, IQ server returns another syntax error below against those queries using LIMIT clause.

E,4,-131,Syntax error near 'limit' on line 2

But, if the option is set to 'LIMIT' for those queries like above, iqunload utility fails due to the syntax error.


Read more...

Environment

SAP IQ 15.4 ESD5, ESD6
SAP IQ 16.0 SP10, SP11

Product

SAP IQ 16.0

Keywords

IQ, iqunload, limit, syntax error, CR 798553, 798553, CR798553 , 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.