External procedures

An external procedure is a script or executable program on a host in your database cluster that you can call from within OpenText™ Analytics Database.

Enterprise Mode only

An external procedure is a script or executable program on a host in your database cluster that you can call from within OpenText™ Analytics Database. External procedures cannot communicate back to the database.

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. Either the file must 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 the database.

After a procedure is created in the database, you can execute or drop it, but you cannot alter it.

In this section