Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limit UPDATE statements to affect only one row
I think Informix deserves better than this even if IBM is treating it like a second-class citizen.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org ----------------------------------- Now if I were posting like this. I would agree with Sybrand. That's bashing. 3. If you posted: Try SELECT COUNT(*) FROM dual The answer would likely be a helpful: "Actually DUAL on DB2 is called SYSIBM.SYSDUMMY1" If you port from Oracle simple define a view for DUAL. I only posted the "won't work" after you started yanking my chain, and I did so matter-of-factly. I will not answer to any further comments on this thread. You are inventing flame where there is none. Cheers Serge -- Serge Rielau DB2 Solutions Development IBM Toronto Lab IOD Conference http://www.ibm.com/software/data/ondemandbusiness/conf2006/Received on Sat Aug 12 2006 - 17:11:48 CDT