[Share] iqunload may give an error
IQ Version : IQ 15.4 ESD6 / IQ 16.0 SP10/SP11
As introduced in a recent blog, iqunload has been enhanced by adding new options to generate table schemas as well as table data.
In a specific case, the iqunload utility may give an error below.
[hpita:/home1/DBA] iqunload -c “uid=DBA;pwd=sql;eng=HPIA16” -tld kw -v -y /work/jerry
SAP IQ Unload Utility Version 126.96.36.1994
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 allow to specify ‘LIMIT’ clause in queries like ‘select … from … order by … LIMIT 0,500;’.
For example, the below statement lists the fifth and sixth employees sorted in descending order by last name:
ORDER BY Surname DESC
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.
That is, it’s a deadlock situation.
This problem has been reported to the IQ development team.
As soon as the syntax error gets fixed, this blog will be updated.
iqunload Utility – For Schema and Data Export – Utility Guide – SAP Library
SELECT Statement – Reference: Statements and Options – SAP Library