Sending Mail | External Stored Procedure Examples | Teradata Vantage - 17.10 - Sending Mail - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
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.