Hi, everybody

I encountered a very strange behavior of DB2. There are two SELECT statements listed below. The difference is presencing UPPER function in the second statement. When I execute these statements (in the same session without any other statements) the first one works properly but the second one returns an exception

SQL0551N "USER1" does not have the privilege to perform operation "EXECUTE"
on object "SCHEMA1.FUNCTION1". SQLSTATE=42501

The first statement:
select *
from table1
where SCHEMA1.FUNCTION1 ( column1 ) = 1

The second statement:
select *
from table1
where SCHEMA1.FUNCTION1 ( upper(column1) ) = 1

table1.column1 and the parameter of SCHEMA1.FUNCTION1 have varchar type.
Execute permition granted to a group containing USER1.
DB2 version: 8.1.1.88 + FixPack 9
Platform: AIX

Any ideas what causes the difference in behavoir. Please advise.

Raise a PMR

Sathyaram

maybe some packages could be missing which need to be rebound to the database. If you do db2 ? sql0551 from windows/unix prompt you'll get the error description, one of which is utility programs missing.

Sorry, but I don't understand what you have meant to say "Raise a PMR"

Thanks for reply!

I'll check your suggestion...

A PMR is a problem that you open with IBM support (they assign a PMR number), assuming that you have a support contract.

Thanks Marcus
I see

Check for the presence of overloaded SCHEMA1.FUNCTION1 and/or UPPER functions; do you have identical problems when column1 is CHAR(1) instead of VARCHAR? Try e.g. SCHEMA1.FUNCTION1 ( upper('a') ) = 1

4 Peter
thank for reply

I have identical problems when column1 is CHAR(1) and
select *
from sysibm.sysdummy1
where SCHEMA1.FUNCTION1 ( upper('a') ) = 1
returns an exception

SQL0551N "USER1" does not have the privilege to perform operation "EXECUTE"
on object "SCHEMA1.FUNCTION1". SQLSTATE=42501