The create timestamp for a user-defined function must be
older than the bind timestamp for the package or plan in which the
user-defined function is invoked. If DB2® authorization
checking is in effect, and DB2 performs
an automatic rebind on a plan or package that invokes a user-defined
function, any user-defined functions that are created after the original
BIND or REBIND of the invoking plan or package are not candidates
for execution.
If you use an access control authorization exit routine,
some user-defined functions that were not candidates for execution
before the original BIND or REBIND of the invoking plan or package
might become candidates for execution during the automatic rebind
of the invoking plan or package. If a user-defined function is invoked
during an automatic rebind, and that user-defined function is invoked
from a trigger body and receives a transition table, the form of the
invoked function that
DB2 uses
for function selection includes only the columns of the transition
table that existed at the time of the original BIND or REBIND of the
package or plan for the invoking program.
