Skip to content

Instantly share code, notes, and snippets.

View arlenstovall's full-sized avatar

Arlen Stovall arlenstovall

  • Indianapolis, IN
View GitHub Profile
@forstie
forstie / Sending an E-mail via SQL.sql
Created June 15, 2019 05:56
Sending an E-mail via SQL
-- setup
cl: STRTCPSVR SERVER(*SMTP) ;
cl: ADDUSRSMTP USRPRF(SCOTTF);
cl: ADDUSRSMTP USRPRF(TIMMR);
-- Send SMTP E-mail Message (SNDSMTPEMM)
cl:SNDSMTPEMM RCP(('forstie@us.ibm.com' *pri)) SUBJECT('hello world again') NOTE('this is a new note');
cl:SNDSMTPEMM RCP(('forstie@us.ibm.com' *pri)) SUBJECT('hello world again') NOTE('this is a new note');
select * from SQLISFUN00.may17objs;