IBM Db2 Big SQL 7.1.0

Developing federated procedures

Federated procedures enable you to invoke procedures at a data source as if the remote procedure is a local procedure.

Federated procedures
A federated procedure is a federated database object that references a procedure on a data source.
Creating federated procedures
You must create a federated procedure for each data source procedure that you want to invoke from the federated server.
Data sources and federated procedures
Before you create federated procedures, review how federation supports data source procedures.
Granting or revoking authorizations to call federated procedures
The administrator of the federated database must grant other users the required authorizations to call the federated procedures.
Displaying parameter information and calling federated procedures
Query the SYSCAT.ROUTINESFEDERATED catalog view to display parameter information. Then use the CALL statement to call a federated procedure.
Altering or dropping federated procedures
You can modify an existing federated procedure by changing the data type of one or more parameters of the federated procedure.
Joining the result sets of federated procedures
You can join the result sets returned by a federated procedure with the DB2FEDGENTF command.
Federated procedure troubleshooting
If you encounter problems with federated procedures, there are several ways that you can troubleshoot the problems.

Parent topic: Administering federation