Re: Exception in this sql

Unfortunately, the original poster doesn't know how to use Google for answering his own questions:

LIMIT 1 is used in an MySQL or Oracle SQL query to limit to one the number of rows selected:
http://lmgtfy.com/?q=limit+sql+query+to+100+rows

FETCH FIRST 1 ROWS ONLY is how you limit to one the number of rows selected in an IBM i SQL query.
http://lmgtfy.com/?q=limit+sql+query+to+1+row+IBM

-sjl


"Glenn Gundermann" wrote in message news:CAOw_mOfGCNnkiKV-Y6rM_3fTgnK-b+LpH3d0OfheFmMB-5MS3w@xxxxxxxxxxxxxx...

I haven't seen LIMIT before and I think that's what it's complaining about.

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144

P

On 21 May 2015 at 18:57, Hoteltravelfundotcom <hoteltravelfun@xxxxxxxxx>
wrote:

I have to make one change to what was done previously. If there are no
'001' rows for the order
then we only want the earliest code.

But this union here is giving an error: SQL0104 - Token LIMIT was not
valid. Valid tokens: ) FETCH ORDER UNION EXCEPT.

CREATE VIEW rklib.clspaytp AS
Select *
from rklib.clspaytpp
where ottrnc='001'
union

select *
from
(
select *
from rklib.clspaytpp
where ottrnc != '001'
limit 1
) x