Installing External Procedure Executable Files
To install an external procedure, use the Administration Tools through either menu or the command line.
Using the Admin Tools Menus
Run the Administration Tools.
- On the AdminTools Main Menu, click Configuration Menu, and then click OK.
On the Configuration Menu, click Install External Procedure and then click OK.
- Select the database on which you want to install the external procedure.
- Either select the file to install or manually type the complete file path, and then click OK.
If you are not the superuser, you are prompted to enter your password and click OK.
The Administration Tools automatically create the
<database_catalog_path>/proceduresdirectory on each node in the database and installs the external procedure in these directories for you.
- Click OK in the dialog that indicates that the installation was successful.
If you use the command line, be sure to specify the full path to the procedure file and the password of the Linux user who owns the procedure file;
$ admintools -t install_procedure -d vmartdb -f /scratch/helloworld.sh -p ownerpassword Installing external procedure... External procedure installed
Once you have installed an external procedure, you need to make Vertica aware of it. To do so, use the CREATE PROCEDURE statement, but review Creating External Procedures first.