SQL path considerations for built-in functions

Function resolution applies to all functions, including built-in functions and other functions provided by Db2. If a function is invoked without its schema name, the SQL path is searched.

With the exception of the Db2 IBM® MQ functions, the built-in functions are in schemas SYSIBM or SYSIBMADM.

Start of change Additional functions are available in other schemas, but are not considered as built-in functions because they are developed as user-defined functions that have no special processing considerations. End of change

If SYSIBM is not first in the path, it is possible that Db2 will select another function instead of the intended built-in function. If schema "SYSIBM", "SYSFUN", "SYSPROC", "SYSIBMADM" is not explicitly specified in the SQL path, the schema is implicitly assumed at the front of the path. Db2 adds implicitly assumed schemas in the order of "SYSIBM", "SYSFUN", "SYSPROC", "SYSIBMADM".