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

You could create a view that uses the table function in the FROM clause and then create a nickname for the view.

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