Hi,
I'm getting the following error when a program generates a query to a AS400 database.
Product=ZWWVI-AUNO Platform=Other Table=IIM
Error -2147217900 [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0104 - Token 99 was not valid. Valid tokens: + - AS <IDENTIFIER>.
SELECT
TOP 99
J1.IID,
J1.IPROD,
SUM(J1.IISS),
COUNT(J1.IISS)
FROM
IIM J1
WHERE
J1.IPROD BETWEEN 'ASP' AND 'ASP100T05'
GROUP BY J1.IID,J1.IPROD
ORDER BY 1,2,3
Do any one no how to solve it?
I think that the command TOP 99 is not valid.
Thanks in advance