Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: calling a Function

    For example I have two users A,B and a function a.func1().

    Is any way there to call func1() from user B without mentioning the schema a.func1() ?

  2. #2
    Join Date
    Jan 2005
    Well no, at some point DB2 needs the "a" to find the real function. But I presume what you're trying to do is enable B to invoke the function without having to code a.func1. Some ways you could try:
    - create function b.func1 source a.func1
    - select current path concat ',A' into :somewhere from sysibm.sysdummy1
    set current path = :somewhere

    James Campbell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts