IBM Information Server, Version 8.1A federated procedure is a federated database object that references a procedure on a data source. Federated procedures are sometimes called federated stored procedures.
A federated procedure is to a remote procedure what a nickname is to a remote table. With a federated procedure, you can call a data source procedure. You can create a federated procedure by using the DB2® Control Center or from the command line.
WebSphere® Federation Server provides the same powerful discovery functions for federated stored procedures as it does for servers, nicknames, and other objects.
Figure 1 shows the Create Federated Stored Procedures window after the Discovery window was used to generate a list of potential data source procedures where Name is like %EMP%. You then select the procedure that you want to create and the DB2 Control Center populates the fields and settings based on information from the data source procedure.
This topic is also in the 