16.20 - Overview - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

This example shows how to send mail on Linux by calling sendmail in an external stored procedure. It is very primitive and does no error checking as good programming practices should. But it does show how relatively easy it is to get an external stored procedure to do something useful. The procedure can be called from within a trigger action body if desired.

Because the external stored procedure does I/O, the definition includes the EXTERNAL SECURITY clause.