By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,328 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

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

P: 2
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
Oct 24 '07 #1
Share this Question
Share on Google+
1 Reply


P: 9
What is Top 99 supposed to mean?
I am not aware of that syntax.
Nov 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more DB2 Database Questions on Bytes