DB2 Version 9.7 for Linux, UNIX, and Windows

CurrentFunctionPath CLI/ODBC configuration keyword

Specifies the schema used to resolve function references and data type references in dynamic SQL statements.

db2cli.ini keyword syntax:: CurrentFunctionPath = current_function_path
Default setting:: See description below.
Usage notes:

This keyword defines the path used to resolve function references and data type references that are used in dynamic SQL statements. It contains a list of one or more schema-names, where schema-names are enclosed in double quotes and separated by commas.

The default value is "SYSIBM","SYSFUN",X where X is the value of the USER special register delimited by double quotes. The schema SYSIBM does not need to be specified. If it is not included in the function path, then it is implicitly assumed as the first schema.

This keyword is used as part of the process for resolving unqualified function and stored procedure references that may have been defined in a schema name other than the current user's schema. The order of the schema names determines the order in which the function and procedure names will be resolved.