Re: SQL/INFORMIX

"Mark D. Stock" <marks@west.co.za> wrote: :T.Merlin wrote: :> :> My request is : :> SELECT ROWID FROM EMP WHERE UPPER(FIRST_NAME)=UPPER('Tyler') :> UPPER is a ORACLE/SQL+ function. :> INFORMIX error is : :> 674: Procedure (upper) not found. :> 111: ISAM error: no record found. :> Can you tell if UPPER or same function exist on INFORMIX. : :You need to create the upper function like so: ...function sniped... Have anyone tested this upper procedure for speed in a statement like the above. It seems to me that it can't be very usefull on anything with any significant number of rows in the table. It will have to not only do a sequential scan, but also evaluate this complex procedure for every row. What we do is to put the upper version of the data in an extra column. That column can then be indexed as well. Much better in most real life cases as far as I can see. It's now due time that Informix either implements this function, or release the Universal Server at the same price as the current OWS/DSA releases. The last would immediately bring Informix back on track. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org