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




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