Let’s look at a quick little example RPG email validation program – SQLRPGLE ILE There are lots of code snippets, example programs, and long waffling discussions in internet land filled with pointy-headed AS400, Series, and IBM i programmer chaps (and chappettes) arguing about the best way to “validate an email address in RPG”. I know

Read More

Email on the IBM i I’ve been chatting with a client of mine about sending emails from his AS400 iSeries Power IBM-i System. More specifically about sending emails from his system, but with the email address of the user that is signed on. This emails send but frequently go to spam. Luckily, setting up IBM

Read More

This morning I awoke to find an email from a digital blackmailer. This email shows one of my commonly used login email accounts plus one of my more commonly used password. Yikes! My password information has been leaked from somewhere! I’ve received several email just like this over recent weeks. Each time it shows my

Read More

Using SQLRPGLE to Validate email addresses in IBM i 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

Read More

IBM i SQL to validate Email So, we have a customer master file 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

Read More

Email an IBM i Output Queue as PDF Email an OUTQ – should be simple right? Here you are, you have this output queue filled with reports and you want to email them to your Boss/Colleague/whoever! You don’t really want them in smelly old text format you want them to look nice in something like

Read More

From AS400 DLS to IBM i IFS Over recent years, I’ve been playing with the IBM i Integrated File System a lot more than usual. The IFS allows us to use and easily share IBM i Data with Windows/Linux/Apple or just about any other computer on the network. It basically shares native IBM i (AS400)

Read More

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  

Read More

UPDATE 2017 – I just added a newer version of this article using IBM i V7R2 HERE Email all Spool Files for IBM I For a couple of years now, I’ve used this little EMLOUTQ utility program (written in IBM i Control Language) to read through an output queue and email each and every spool

Read More

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

Read More

In yesterdays blog (how to display images in Google mail), I mentioned the excellent Blank Canvas Gmail Signature FireFox Add-on (wow that’s a mouthful 😉 ) which allows rich text html style signatures to be appended to emails from within Google email. I was surprised to find a couple of private mails this morning asking

Read More

Are you annoyed that gmail only lets you setup a very dull email signature? I personally think that flat format text signatures are long-winded and just fill emails with thousands of words of *cough* crap. I especially hate people who waste hundreds of bytes of storage with instructions “not to print this email because it

Read More