From AS/400 to iSeries to System i to IBM i on Power
Leave a ticket on the helpdesk if you cant find what you need or have a request for a new lesson or blog
IBM RDi Rational Developer Ports What TCPIP ports are used by IBM RD/i? I’ve been struggling to get Rational Developer working while remote during the ‘Rona. While I’m working locked in my cellar, candles flickering, dogs growling and rats a scurrying, my laptop is connected with VPN and my guess is that VPN is blocking …
Use the Retrieve Job Attribute (RTVJOBA) command to snaffle the job’s run type from the attributes. Seems pretty obvious right? One little niggle was that the RTVJOBA passes back a char(1) value for the jobtype where ‘0’ means batch and ‘1’ means interactive. But, I want to be able to neatly compare a logical value …
AS400, IBM i, iSeries, Programming, RPG
Developerworks Connections is dead As I was waffling this morning about the sad demise of IBM Developerworks Connections Wiki – here is another excellent article that discusses various extensions to IBM Rational Developer for IBM i – How to Extend RDi (#RDi) So here it is, re-posted before IBM can hide this wonderful source of …
AS400, IBM i, iSeries, Programming, RPG
I was discussing the benefits of RDi with a colleague this morning (I’m a bit of a Rational Developer fanboy) because he is trying to justify the huge annual cost of the tool with The Management: nearly $1000 per year per person! A price tag that is #bloodypreposterous. But, I will rant about that in …
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 …
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 …
Talking to a colleague this morning, we were discussing a vendor supplied series of spreadsheets (in CSV format) that his team needed to process. “What’s the best way to read all the spreadsheets in an IFS folder so we can process them?” bald bloke in the office Well, we have a nice simple technique to …
How to Edit UIM MENUs with Rational Developer for IBM i Today I be mainly playing with UIM MENU’s that bloke from the fast show … and I found that Rational Developer for IBM i doesn’t come out of the box ready to edit UIM MENU source types! So, if like me, you are playing …
I found this wonderful article over at Midrange Blog It does exactly what I am trying to do: Lets me encrypt a certain field (column) in a table so that its encrypted as its added and updated. It also lets me automatically decrypt it when I read the record back (the only caveat is that …
This morning I had an email from a blog subscriber ( Hi Rick! ) asking for a code tips on how to cleanup IFS file names to remove erroneous characters and/or malformed directory name slashes. Rather than reply with a plethora of programming options — here is an old, but functional, RPG code snippet that …
IBM i SQL – Using SUBST A while ago I had a problem where I wanted to change the first two characters in a table and I used the very simple concat and subst operations to do it with SQL. Today, we had a slightly more complex requirement of updating text in the middle of …