[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 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 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:

  SELECT *

  FROM Employees

  ORDER BY Surname DESC

  LIMIT 4,2;

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