Specifies the function path to be used in resolving user-defined distinct types and functions in static SQL. If this option
is not specified, the default function path is:
"SYSIBM","SYS FUN",USER
where USER is the value of the USER special register. This DB2 precompile/bind option is not supported by DRDA.
Syntax:
FUNCPATH=schema-name
NOFUNCPATH
Parameters:
|
schema-name
|
is a short SQL identifier, either ordinary or delimited, which identifies a schema that exists at the application server.
No validation that the schema exists is made at precompile or at bind time. The same schema cannot appear more than once in
the function path. The number of schemas that can be specified is limited by the length of the resulting function path, which
cannot exceed 254 bytes. The schema SYSIBM does not need to be explicitly specified; it is implicitly assumed to be the first
schema if it is not included in the function path. For more information, see the IBM DB2 SQL Reference.
|