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
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.