Connecting Tech Pros Worldwide Forums | Help | Site Map

Error -2147217900 [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0104

Newbie
 
Join Date: Oct 2007
Posts: 2
#1: Oct 24 '07
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

Newbie
 
Join Date: Oct 2007
Posts: 9
#2: Nov 2 '07

re: Error -2147217900 [IBM][Controlador ODBC de iSeries Access][DB2 UDB]SQL0104


What is Top 99 supposed to mean?
I am not aware of that syntax.
Reply