Re: Upper problem
UPPER isn't in all versions of Informix.
From: Sven Coppens <sven.coppens@teleatlas.com>
>
>I have got the follow error message when I used the Upper procedure.
>
>Error message
>SQL Error (-674): Routine (upper) can not be resolved
>
>SQL statement
>SELECT *
>FROM SMED
>WHERE UPPER(M_ARCHUSER) = 'PDV'>
>Could some one tell me how I have to solve this problem. The informix
>error help gives me following hint:
>"Routine routine_name not found.
> You called a routine that does not exist in the database. If you invoke
>the routine, but your application or another application drops the
>routine before you execute the prepared statement, you receive this
>error."
>
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com