DB2 10.5 for Linux, UNIX, and Windows

CurrentFunctionPath CLI/ODBC configuration keyword

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

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

The CurrentFunctionPath 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 quotation marks and separated by commas.

The default value is "SYSIBM","SYSFUN",X where X is the value of the USER special register delimited by double quotation marks. 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.

The CurrentFunctionPath keyword is used to resolve unqualified function and stored procedure references that might be 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 are resolved.

IBM® Informix® servers do not support the CurrentFunctionPath keyword. Do not specify the CurrentFunctionPath keyword in a connection to IBM Informix servers.