Not only that, the solution is in the DB2 reference manual.

-----Original Message-----
From: Heijer Rob den
[mailto:db2udbdba-ezmlmshield-x28488791.[Email address protected]
Sent: Tuesday, August 30, 2005 1:38 AM
To: LazyDBA Discussion
Subject: RE: fetch row

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







---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

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