It is not often that the solution is in your message, but this time indeed it is ;-)
I saw that others have already responded, but I could not resist.
Rob.

-----Oorspronkelijk bericht-----
Van: Amit Singal [mailto:db2udbdba-ezmlmshield-x74815017.[Email address protected]
Verzonden: di 30-8-2005 7:15
Aan: LazyDBA Discussion
Onderwerp: fetch row

select * from try fetch first 2 rows

I am getting following error while executing the query:

An unexpected token "END-OF-STATEMENT" was found following "y fetch first 2
rows". Expected tokens may include: "ONLY".

Kindly Suggest the solution

Regards

Amit Singal






DB2 & UDB email list listserv db2-l LazyDBA home page