Implementing External Procedures

To implement an external procedure:

  1. Create an external procedure executable file.

    See Requirements for External Procedures.

  2. Enable the set-user-ID(SUID), user execute, and group execute attributes for the file. The file must either be readable by the dbadmin or the file owner's password must be given with the Administration Tools install_procedure command.

  3. Install the external procedure executable file.
  4. Create the external procedure in Vertica.

Once a procedure is created in Vertica, you can execute or drop it, but you cannot alter it.