Upper(datafield) in Informix 5.0
Toni Graybill found the UPPER function missing in Informix 5.0. Robert Vorbroker said this was a known limitation in 5.0 and earlier, which is why his shop forced uppercase character data, and pointed to the IIUG code archive. Art Kagel said the IIUG Software Repository has a slow but usable UPPER stored procedure.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
I am supporting a legacy Informix 5.0 database. I'm trying to do a lookup on user names. Normally I would execute a sql command like the following to do this: select upper(username) from usertable order by upper(username); But the upper function does not seem to exist in Informix 5.0!!! Any old-timers out there who have wrestled with this one? Or do I just spool to a file & do a shell script for the ascii conversion??? Thanks! Toni
This was always a problem in 5.0 and earlier. That is the MAIN reason we forced CHARACTER fields to only have UPPER CASE values. If I can find the appropriate code snip I will forward to you. Check the code vault at www.iiug.org - lot's of good stuff there - maybe what you are looking for. Good Luck. Rob Vorbroker Toni Graybill <toni_graybill@non.hp.com> wrote in message news:3A3EAE3C.CB75D49D@non.hp.com... > I am supporting a legacy Informix 5.0 database. I'm trying to do a > lookup on user names. Normally I would execute a sql command like the > following to do this: > > select upper(username) from usertable order by upper(username); > > But the upper function does not seem to exist in Informix 5.0!!! Any > old-timers out there who have wrestled with this one? Or do I just spool > to a file & do a shell script for the ascii conversion??? > > Thanks! > Toni >
There is an UPPER store procedure, slow but usable, in the IIUG Software Repository. Art S. Kagel Toni Graybill wrote: > > I am supporting a legacy Informix 5.0 database. I'm trying to do a > lookup on user names. Normally I would execute a sql command like the > following to do this: > > select upper(username) from usertable order by upper(username); > > But the upper function does not seem to exist in Informix 5.0!!! Any > old-timers out there who have wrestled with this one? Or do I just spool > to a file & do a shell script for the ascii conversion??? > > Thanks! > Toni
Thanks Art, I knew I remembered something in the IIUG archives but didn't have time to investigate it for Toni. Toni - I leave you in the wealth of Mr. Kagel's knowledge... Rob Vorbroker Art S. Kagel <kagel@bloomberg.net> wrote in message news:3A4133EC.F9CAD703@bloomberg.net... > There is an UPPER store procedure, slow but usable, in the IIUG Software > Repository. > > Art S. Kagel > > Toni Graybill wrote: > > > > I am supporting a legacy Informix 5.0 database. I'm trying to do a > > lookup on user names. Normally I would execute a sql command like the > > following to do this: > > > > select upper(username) from usertable order by upper(username); > > > > But the upper function does not seem to exist in Informix 5.0!!! Any > > old-timers out there who have wrestled with this one? Or do I just spool > > to a file & do a shell script for the ascii conversion??? > > > > Thanks! > > Toni