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 WaffleAS400 , IBM i , 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 WaffleIBM i , IFS , Programming
Colleague asked me this question just a minute ago – as he said “its obvious when you know how but not when you dont” Simply use the IBM i RNM command: Personally, I find this command syntax a little annoying: fully qualifying the FROM string and then just using the unqualified NEW file name in […]
More Waffle
AKA – How to copy IBM i IFS folder and all subfolders and documents to a new Location I just upgraded a clients PRESTO Server to the current version 8.1 What is Presto? It’s commonly called an IBM i Modernization Application : Essentially transforming the old fashioned AS400 style Green Screen terminals to modern Webstyle […]
More WaffleAS400 , IBM i , iSeries , Website
So, I just did an upgrade of the BCD Software GUI Client (now owned by Fresche Legacy by the way) for a client. This upgraded their older version of Presto to PRESTO 8.1 Server. This also comes with a new Presto Client and Screen Designer adding some nice new tweaks. Compulsive Library Naming Tendencies The […]
More Waffle