I have an external function that we use in our CRM system, and my
application owners would like to know the last time it was bound in
the database. I've checked in syscat.functions, routines, and
packages, but the filename isn't located anywhere in those views. Is
there another table or view I can check ?

Hi,

Can you please be a little bit more specific? External functions are not bound
to the database, except, if parts of them were written with embedded SQL
(which requires a precompiler).

Are you talking about a user defined function, a stored procedure, a table
function? Which language was used?

e.g. a UDF written in C has its filename in the IMPLEMENTATION column:

select funcname,create_time,implementation from syscat.functions where
funcname = 'YOUR_FUNCTION_NAME'

The implementation column will look something like a!b
where a is the filename and b the functionname in the C code.

Btw, the create time is the time you registered the function, not the time the
function was compiled. If you want the compile time you have 2 options:

1) check the timestamp in the sqllib/function directory (which can be wrong if
someone copied the file later than it was compiled
2) implement a compile time flag into the UDF

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/