Tag Archives for " #email "

Jun 13

Funky IBM i Email Validation Program using SQL Regex

Following on from my previous blog (basic email validation) I decided that it would much nicer to (a) have the regex stored in a data area so that we can easily play with it to try different validation scenarios and (b) lets have a shot at a much stricter validation because there is an official […]

More Waffle
Jun 13

Simple email validation SQL RPG ILE program

There are lots of code snippets, example programs and long waffling discussions in internet land filled with pointy headed AS400, iSeries and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know because I’ve read nearly all of them, as well as tried all the […]

More Waffle
May 12

Use IBM i SQL to validate email addresses in Customer Master File

So, we have a customer masterfile that’s been around for years. Users have been keying in customer info and sometimes adding email addresses, sometimes not, sometimes entering nonsense or even just text that says things like “this chap has no email so don’t email him”. Yes, it’s a filthy dirty file filled with grubby email […]

More Waffle
Oct 04

Email every spool file in an output queue – EMLOUTQ for IBM i

Email an OUTQ – should be simple? Here you are, you have this output queue filled with reports and you want to email them to your Boss/Colleague/whoever! You dont really want them in smelly old text format you want them to look nice in something like PDF format…. That should be easy right? IBM i […]

More Waffle
Aug 16

Send IBM i Email including SQL Table Data automatically

Have you ever wanted to extract some data out of an IBMi/AS400 file using SQL and then email that data to someone as an Excel Spreadsheet? Now you can… all from one IBMi command without having to write any CL code to do it. Projex4i: DSTDTA command now handles SQL STRINGS for selecting data   […]

More Waffle
Mar 31

Working on a new signature for my emails .sig

So, this week I’ve been playing with my email signature. Over the years my email sig has changed with the fashion of the moment. From simple “Cheers, Nick” to gloriously wordy tomes containing “please dont print this it kills the trees and trees make air which we breathe so if it all goes away it […]

More Waffle
Nov 25

IBM i Emails with IFS attachments from RPG and CL using SNDSMTPEMM

Life as a IBM i Software Developer is fun, but life as an AS400 software maintenance programmer can be a bit grim. I seem to spend the bulk of my time maintaining older applications – archaic code monstrosities that started life in the AS400 generation. “The AS400 generation?” You remember these days in the early […]

More Waffle