Dear Amit,

If it is DB2 in MF then please use

select * from try fetch first 2 rows ONLY

Thanks & Bestrgds
Sreeramoju Pavan Kumar


Tata Consultancy Services Limited
International Tech Park,
Innovator, 11th Floor,
Whitefield Road,
Bangalore - 560066,Karnataka
India
Mailto: sreeramoju.[Email address protected]
Website: http://www.tcs.com



"Amit Singal " <db2udbdba-ezmlmshield-x74815017.[Email address protected]
08/30/2005 10:45 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

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


ForwardSourceID:NT0000668E


Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

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