RE: Upper problem
Hello Sven,
UPPER (LOWER,INITCAP,CASE,DECODE,NVL ...)
exists in SQL, but from engine version IDS 7.3x
Pepa
-----P'vodn' zpr'va-----
Od: Sven Coppens [mailto:sven.coppens@teleatlas.com]
Odesl'no: 8. 'nora 2000 13:38
Komu: informix-list@iiug.org
P'edm't: Upper problem
Hello,
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."