Category Archives for "RPG"

Aug 08

RPG Program Source Code – Clever or Clear?

I’ve been working on an interesting project focused on taking some old RPG code and re-factoring it to make it more efficient. Fascinating work for a client that is focused on doubling its IBM i throughput and reducing the CPU load of all its old programs. This has frequently made me choose between writing a […]

More Waffle
Aug 01

Get the IBM i System Name using RPGLE or SQLRPGLE

Get Sysname using SQL The IBM i System Name is not the same thing as the SQL Local DB Server name, although it may be the same by default. You can retrieve the SQL Local DB Server name using this SQLRPGLE code snippet: exec sql values current server into :systemName; If systemName = ‘my-ibm-i-system-name’; do […]

More Waffle
Aug 01

Use substring in RPGLE SQL Statements

So, I had to make a little change to an RPG4 program to let it respond to a new parameter being passed into it via JSON. This value had to be stored in the first character of a field in a physical file in the database. Simple Logic and we want it done quick, efficient, […]

More Waffle
Jul 30

What’s the best Free RPG Editor?

If you are reading this blog then chances are you are (a) an RPG Programmer and (b) using SEU to edit your code and (c) you are frustrated that SEU wont syntax check new RPG anymore! It’s time to leap into an RPG EDITOR or be pushed… RDi is bloody good but it’s also a very expensive code […]

More Waffle
Jul 27

JSON versus JSONP Tutorial – Resurrected

So, I was searching for information on JSON versus JSONP and, more specifically, how to handle JSONP with IBM i Y.A.J.L and I stumbled across this old archived website. The actual domain is dead, but I found this information on the internet way back when archive site. It’s worth saving – so here it is! […]

More Waffle
Jul 26

RPG, PHP and MYSQL

I wish I could take credit for this article. But I cant 🙂  It hits the nail on the head and the author (Daniel Gray) explains himself very clearly: Getting up to speed with PHP on the IBM I If I can, I’d like to offer my IBM I friends some advice on getting up […]

More Waffle
Jul 26

Right Adjust Numeric into Alpha field using RPG Free

I have a NUMERIC in an RPG program that I want to move RIGHT into an Alpha field. In the old days of RPG3 I would use MOVE but in the new days of RPG4 I have a couple of more flexible solutions. So, lets say we have a numeric field containing the number 1234, […]

More Waffle