Re: UPPER() doesn't work for IUS 9.14?

Posted in 1998

Clem Akins — Mon, 16 Nov 1998 05:17:23 -0800 — source: Informix-list mailing list archive (1991-1998)

At 11:16 AM 16-11-98 GMT, leehaw@silkroute.com wrote: >Hi guys, > >I have IUS 9.14 with Web Datablade, running on Sun Solaris 2.6. > >The upper() function doesn't work for me. Using dbaccess, a SQL statement like >this: > >select upper(description) from my_table > >Will throw an error message "Routine (upper) can not be resolved". Is this= an >expected behaviour? > >BTW, "description" is a VARCHAR(255). Yes, this is expected. The UPPER function is not available in the 9.1x program. It comes in the 7.3/9.2 versions. 7.3 is available now, but 9.2 will not be generally available until next year. The 9.1x engine is searching for your own personal routine named UPPER (which you can certainly create and use) and not able to resolve it. _______________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Customer Course Development Informix Software, Inc Last seen: Auf den H=F6fbrauhaus, in M=FCnchen, Deutschland