To All,
Below is what I found on page 809 in the DB2 Universal Database V8 for
Linux, UNIX, and Windows Database Administration Guide by George Baklarz
- Bill Wong.

User-defined functions (UDFs) are like any other database object in DB2,
meaning that each UDF has a schema name associated with it. Ideally,
each UDF is fully qualified when it is called. However, this can be
quite difficult and can limit the flexibility of SQL queries. The
alternative is to use the special register CURRENT FUNCTION PATH. DB2
uses this path to resolve unqualified function references. The path in
this case is not a list of all directories, but a list of schema names
such as "SYSIBM", "SYSFUN", or "EDWARDE". SYSFUN is the schema used for
built-in UDFs. Note that the authorities needed to create UDFs are the
same as those required to create stored procedures.

Oh my! Phew! Ouch! What the heck? What is IBM trying to say? Hehe.



-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x67556809.[Email address protected]
Sent: Tuesday, December 12, 2006 4:04 AM
To: LazyDBA Discussion
Subject: RE: DB2 Version 8.2, Fixpack 7, for Windows (CURRENT FUNCTION
PATH)

Hey Alex,
You didn't answer the question below? Hehe.


-----Original Message-----
From: Edwards Ed
[mailto:db2udbdba-ezmlmshield-x46925600.[Email address protected]
Sent: Monday, December 11, 2006 9:55 AM
To: LazyDBA Discussion
Subject: DB2 Version 8.2, Fixpack 7, for Windows (CURRENT FUNCTION PATH)

To All,
Has anyone used the CURRENT FUNCTION PATH in a stored procedure or
stored function? If so, could you provide me with an example?


BTW, we are using the following code to sort of accomplish what the
CURRENT FUNCTION PATH supposedly does.

GRANT EXECUTE ON PROCEDURE DEPBWS.* TO USER "ED.EDWARDS";

GRANT EXECUTE ON FUNCTION DEPBWS.* TO USER "ED.EDWARDS";


Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page