Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Posts
    6

    Unanswered: Calling a DB2 z/OS UDF from a DB2 LUW db

    Greetings,

    Is it possible to call a DB2 z/OS TABLE UDF from a DB2 LUW database?
    Something like how how nicknames work, but for functions?

    The manual states that
    "A create function mapping to remote functions that returns a table or a row is not supported in a federated database."
    Does anybody know of a work around for this? I can't create a view of the z/OS udf as it requires three input parameters

    Thanks
    Alex

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You could create a view that uses the table function in the FROM clause and then create a nickname for the view.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Oct 2010
    Posts
    6
    Knut,
    Thanks for the suggestion, but the table udf works off multiple input parameters, which would require that I have multiple views, one each for every parameter combination.
    I do have a few views that are defined off table functions that are currently implemented, but all of them do not have any input parameters or have input parameters that are relatively fixed. I was hoping that v9.7 had something new

    Oh well, back to the drawing board

    thanks again,
    Alex

    Quote Originally Posted by stolze View Post
    You could create a view that uses the table function in the FROM clause and then create a nickname for the view.

Tags for this Thread

Posting Permissions

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