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.

Start of change With the exception of the DB2 MQSeries® functions, the built-in functions are in schemas SYSIBM or SYSIBMADM. End of change

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. User-defined functions cannot be defined in the SYSIBM schema (or any schema where the name begins with "SYS"). 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" 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".