Instead of ROWNUM ,use FETCH FIRST 1 ROWS ONLY


-----Original Message-----
From: Amit Singal
[mailto:db2udbdba-ezmlmshield-x33779744.[Email address protected]
Sent: Friday, July 29, 2005 5:39 PM
To: LazyDBA Discussion
Subject: rownum

select FirstName || ' ' || LastName into vOutput from users u,
casedatainvestigator cdi
where u.userid = cdi.userid and rownum=1;

db2 doesnot able to identify rownum ::: ROWNUM" is not valid in the
context
where it is used.
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


---------------------------------------------------------------------------------------------
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message.

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