Unanswered: problem calling remote UDF in federated database
I am trying to set up federation between 2 data bases A and B (both are on v9.7 FP6-AIX)
Database A - database containing the source tables and UDFs
Database B- Enabled the federation here, created nickname,function template and function mapping.
create function test.func1_template(varchar(), varchar()) returns integer as template deterministic no external action
create function mapping test_func1 for test.func1_template(varchar(), varchar()) server type db2/udb options(remote_name 'FUNC1')
I have created nick name on source table . Able to view the contents using nick name from the source table i.e. in A
But I am unable to call this function test_func1
It always throw error:
SQL0440N No authorized routine named "FUNC1" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884
I am able to call my remote UDF using the template defined in database:B ,but not able to call using the mapped function.