HI Amit,



Select * from try fetch first 2 rows only;

Thanks & Regards
Kulvinder

-----Original Message-----
From: Amit Singal
[mailto:db2udbdba-ezmlmshield-x74815017.[Email address protected]
Sent: Tuesday, August 30, 2005 10:45 AM
To: LazyDBA Discussion
Subject: 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
DISCLAIMER: The information in this message is confidential and may be
legally privileged.It is intended solely for the addressee.Access to this
message by anyone else is unauthorised.If you are not the intended
recipient,any disclosure,copying,or distribution of the message,or any
action or omission taken by you in reliance on it,is prohibited and may be
unlawful.Please immediately contact the sender if you have received this
message in error.Thank you.

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