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 i Email and SPF will […]
More Waffle
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 character data. The nature of a data area is that its a string of data that can contain a mixture of various data formats. If we […]
More Waffle
Submitting jobs from within IBM i Control Language programs is a doddle. But sometimes we want to know the job name, or job queue, that the job was submitted with. This is easy to do in CL, and since my colleague John “who’s surname cant be mentioned or else it will give him an internet […]
More Waffle
Over on the RPG Cafe website, a nice chap called Smit Dixit published a sample of his RPGLE code calculating the Levenshtein distance between two words. What is the Levenshtein Distance? The Levenshtein distance is a string metric for measuring difference between two sequences. Informally, the Levenshtein distance between two words is the minimum number […]
More WaffleIBM i , Software Change Management , SQL , Turnover
One of the mumbling, drooling, gray haired programmers on my team asked me to peer review his code this morning. This was for a simple SQL table to be created and promoted through multiple environments using TURNOVER. The code looked something like this: CREATE TABLE MYLIB/TESTSQL ( TSTFLD CHAR(10) CCSID 37 NOT NULL DEFAULT ” […]
More Waffle
IBM-i ACS is JAVA based, so it can be installed on Windows, MAC & Linux devices. The legacy IBM Client Access is no longer supported. IBM Client Access & ACS can both be installed on the same PC and live quite happily next to each other. So what are you waiting for? Standalone install By […]
More Waffle
The content of this document was last updated on: March 29, 2019 Contents: 1.0 Introduction2.0 Installation for Windows3.0 Installation for Mac4.0 Installation for Linux5.0 Installing Updates6.0 More Information7.0 Uninstall 1.0 Introduction This guide provides instructions on how to deploy this product on a local disk drive for a single user. There are a variety of […]
More Waffle
Now that’s a mouthful! So, I’ve been asked to install the latest July 2019 version of Lansa Axes (v4.2.0) for a client. Axes is a web application, running on your IBM i Server, which will replace old traditional green-screen 5250 terminal screens like this: to this: Remove any previous versions of LANSA AXES GO LICPGM […]
More Waffle
Some of IBM’s error messages are more cryptic than others. Copying files from the IFS using CPYFRMIMPF sometimes spits out error messages which are less than clear: CPYFRMIMPF FRMSTMF(‘/FOLDER/FOLDER/FILE’) TOFILE(*LIBL/FILENAME) MBROPT(REPLACE) RCDDLM(LF) STRDLM(NONE) RMVBLANK(NONE)FLDDLM(TAB) ERRRCDOPT(REPLACE) RPLNULLVAL(FLDDFT) File system error occurred. Error number 3021Copy command ended because of error. Internet Search for CPYFRMIMPF 3021 shows nothing! […]
More WaffleIBM i , AS400 , IFS , iSeries , SQL
A little while ago, I wrote a data obfuscation tool – which I decided to call Data Fogging. This is specifically to solve the data privacy problems that we face when we want to suck down real data from production environments to our development and Test/QA boxes. Obviously we don’t want to implement any real […]
More Waffle