How to send Teradata SQL query results in email body using stored procedure or BTEQ?

Tools & Utilities
Visitor

How to send Teradata SQL query results in email body using stored procedure or BTEQ?

 
1 REPLY
Teradata Employee

Re: How to send Teradata SQL query results in email body using stored procedure or BTEQ?

A SQL Stored Procedure cannot send email. In principle a system might be configured to allow an external Stored Procedure to send email, but at most sites this is not permitted either.

 

With BTEQ you would need to .EXPORT the query results to a text file, then use the .OS command to invoke some script or program that creates an email and copies the text file into the body.