IBM i SQL numeric to alphameric So – today I was talking to a colleague who wanted to make a database change to a big old file. This meant changing one of the fields from 7 numeric to 12 alpha. Sounds simple right? Oh if only life were that simple… Now add the complexity that

Read More

Microsoft Project 2010 is arguably the best project management application out there. I regularly brush with it, see its efficacy, try to use it but will sooner later get confused by gantt charts and how they can be setup. I always seem to spend a lot of time trying to create a Project before completely

Read More

I recently discovered a new SEO plugin in the WordPress world – RANK MATH and its bloody good! Rank Math is a FREE WordPress plugin for writing SEO friendly content and ranking higher in search engines. Rank Math SEO plugin helps YOU optimize your content for search engines and outrank your competitors. Rank Math features

Read More

I haven’t enjoyed a decent blog rant for some time so… nothing technical in this blog but lots of blowing off steam 🙂 There is a disturbing trend of anti-intellectual elitism in 2019 American culture: the flippant dismissal of science, the decline of arts and humanities. Critical thinking is being replaced by entertainment, self-righteousness, ignorance,

Read More

This morning, I got a little linkedin notification from a subscriber letting me know that my nicklitten blog was exploding ( Thanks Toby 😉 ) I log on and see all kinds of weird WordPress 5.3 Upgrade Error with Thrive Architect PHP ERRORS on the front screen: Warning: Declaration of TCB_Menu_Walker::walk($elements, $max_depth) should be compatible

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

Submitting jobs from within IBM i Control Language programs is EASYBut 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 ShhhItsAsecret â€œwho’s surname can’t be mentioned or else it will give him an internet presence alerting the FBI, NSA

Read More

How do we license and register IBM RDi? So, let start this silly blog assuming you have an IBM Rational Developer (RDi 9.5) license but you want to know how to add the license to the new RDi version 9.6! The new version needs a new License code to be downloaded and installed from IBM.

Read More

Going for the Guinness Book of Records for vague blog titles I decided to waffle about inner joins and outer joins in the world of bellybuttons *cough* Structured Query Language. Since plagiarism is the best form of flattery, Chirag Sharma (over at Guru99) wrote a very nice article about the finer points of SQL INNER

Read More

Bloody Annual License Codes If you have ever scratched your head wondering how to set the license key in SOFTLANDING SOFTMENU then you have joined my club: I googled, binged, ducked ducked and went for an answer to “how to add authorization code to softlandings softmenu” until I was blue in the face, impatiently tapping

Read More

Going the (Levenshtein) Distance 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

Read More

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