Only Numpty Programmers hardcode library names #internetfact 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

Read More

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

Read More

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

Read More

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!

Read More

How to upgrade Turnover V100 to V101 – IBM i Software Change Management Application Grab the latest Turnover ZIP file from your supplied IBM i CD or from http://support.softlanding.com This zip file contains the IBM i software for TURNOVER® for iSeries v100. Lets do this!

...
Read More

IBM i Data Obfuscation – Making Data Foggy Murky and Squinty 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

Read More

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

Read More