“So, I have my name as a domain (www.NickLitten.com) and I want to use as a link to a specific node on the nicklitten.com main site – namely my RESUME page at (www.nicklitten.com/nick.litten)… I wonder how I can redirect a domain name to a specific page on my website?” Sounds like a simple question but

Read More

This is an MC Press article but I am republishing because it’s exactly what I was asked to do today “Adding GPS with RPG”. Do you realize how much your business can do with GPS coordinates? No? Well, let me tell you. All of our applications’ databases hold hundreds if not thousands of addresses—from our

Read More

AS400 Client Access is dead – long live IBM i ACS (Access Client Solutions) also known as: Who killed AS400 Client Access? Ask any AS400 programmer, iSeries Developer or IBM i Nerd and they will all tell you that good old “Client Access” is a pain in the arse! Client Access was introduced back in

Read More

IBM has announced it’s latest round of “technology Refreshes” (aka PTF’s or service packs) for the IBM i operating system. A couple of nice tweaks to RPG are included in TR9 for IBM i 7.1 and TR1 for IBM i 7.2. For RPG, we will have enhanced ALIAS keyword support, and a streamlined DataStructure I/O

Read More

This is just a memory jogger for me and while I was typing this in my notes I realized that someone else may have asked the same question: “How do I see the status of the System 21 (JBA/GEAC/INFOR) background jobs to see what is running?“ I feverishly search the interweb superhighway and apart from

Read More

Steps to remove code from scheduled Releases Simple steps to archive Turnover objects using Turnover Change Management for IBM i ( and the older iSeries / AS400 machines) TO – Turnover Menu Option 9 – Work with Projects and Tasks Create a Worklist and then Checkout program at top level (presumably your production level) Option 46

Read More

Having worked in IT for decades this is absolutely spot on:

A man in a hot air balloon, realizing he is lost, reduces altitude and spots a hiker below. He descends further and shouts to the man on the ground "Ahoy there, can you help me? I promised a friend I would meet him an hour ago, but I don't know where I am"

The chap below looks up, grins and says "You're in a hot air balloon, hovering approximately 30 feet above the ground. You're between 40 and 41 degrees north latitude and between 59 and 60 degrees west longitude."

"Wow! You must be in IT," says the balloonist.

"Actually I am" replied the hiker "How did you guess that?"

"It's quite obvious really" answers the balloonist "everything you have told me is technically correct but I've no idea what to make of your information and the fact is I'm still lost. Frankly, you've been no help. If anything, you've delayed my trip!"

The chap below laughs and says "Ahh yes, you must be in Management."

...
Read More

Data Area (*DTAARA) using IBM i SQL Our first problem is, SQL doesn’t know what a *DTAARA is. SQL reads data from Tables but our gloriously quirky IBM i Box has other places to secretly store data. Data Areas are just one of these tricky little blocks of data that other machines don’t know about

Read More

Are you still running the archaic WDSC7? So we already agree that using WDSC for IBM i software editing, for free, is pretty cool. But, adding Turnover V100 to it, so you can do everything from one place is even cooler. Once we have added the Turnover perspective to our existing WDSC7 setup then we

Read More

Bloody VPN is giving me a headache! Microsoft released an update to Win8.1 this week — which has screwed my Cisco VPN connection. Again. I thought it was only my Win10 laptop that was hating Cisco VPN but I think there is a developer on the Windows team that hates Cisco… lets call him “Henry”.

Read More

Where can I get the AS/400 Client Access Express for Windows software? In the olden days before the IBM System i… in fact wind back a few years earlier until you get to the old IBM iSeries hardware… dont stop… keep going back into history until you get to the venerable IBM AS400 system… The

Read More

Example RPGLE web service programHere is a quick little example RPGLE web service – it’s written in RPG, the SQLRPGLE flavor and simply reads a file (the System/21 Stockroom master file — INP20) and returns a multi-occurrence data structure (array) of the stockrooms that the user is authorized to use. #hopeithelpssomebodyWEBGETSTR – get all stockrooms for

Read More