I was trying to ruin a simple query checking the avreage of a column:

SELECT AVG(<COLUMN_NAME>) FROM <TABLE_NAME>

Got the folowing error:
[IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named
"AVG" of type "FUNCTION" having compatible arguments was found.
SQLSTATE=42884

I thought functions were just inhereent?!? I checked and don't see any AVG function owned by SYSIBM. Nor do I see MAX, MIN, etc.

Did someone not set up our database wrong?

What is the column type you pass as the parm ? The column type shoud be numneric ?

This should work

with temp(a,b) as
(
values(1,1),(2,2),(3,3)
)

select avg(a) from temp
;


HTH

Sathyaram

It looks like you've succeeded :-)

That error message could also be an indication of an incompatible column type being supplied to the function. Try CASTing the column to something numeric.

I did, I did ruin a simple query!!!

My goof - incompatible column type. Chose the wrong column - works like a charm.

Please feel free to ridicule at will....