Creating federated procedures

You must create a federated procedure for each data source procedure that you want to invoke from the federated server.

Before you begin

• The data source procedure must already exist.
• The wrapper for the data source was registered, and the server definition was created.
• Any necessary user mappings were created.
• The privileges held by the authorization ID of the statement include at least one of the following:
  • IMPLICIT_SCHEMA privilege on the database, if the schema name of the procedure does not refer to an existing schema
  • CREATEIN privilege on the schema, if the schema name of the procedure refers to an existing schema
  • SYSADM or DBADM authority
• The privileges held at the data source by the authorization ID must also include the privilege to select the procedure's description from the remote catalog tables.

About this task

To create a federated procedure, you use CREATE PROCEDURE (Sourced) SQL statement