IBM i, Programming, RPG, SQL

Funky IBM i Email Validation Program using SQL Regex

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, RPG

Updating Numeric DTAARA in RPGLE

Numeric Data Areas are a little trickier than Alphameric Updating any numeric DTAARA in RPGLE is slightly different in RPG /FREEFORMAT than in the good old fashioned column based RPG/400. Using RPG ILE, data structures are treated as mixed-character data. The subfields making up a data structure can be a mix of all data types: …

 Read More