RPG is not a Rocket Propelled Grenade RPG2 is that Logic Cycle Thing RPG3 is the System/38 version RPG400 is the revamped RPG3 that came with AS400 ​everything after that is RPG… unless its ILE then its RPGLE or sometimes RPG4, or its free format so its RPGLE /Free… or its SQL so its RPGSQL

Read More

Preparation Notices: Expect 30 – 45 minutes for per installation. Installation requires Administrator permissions and a computer reboot(s). If MS Office, Office360 or other products are required, it is recommended that all applications be installed before Client Access is installed. If this is an IBM Client Access upgrade, the installation will attempt to un-install any

Read More

Today, I was talking *techie* to a colleague in I.T. who still calls the IBM i Operating System – ‘The AS/400’. (but dont get me started on that) We bumped over a few ‘technology sleeping policemen’ during the conversation. Software is easy to upgrade. Mindsets are sometimes overlooked. This reminded me of the importance of

Read More

Do you want to play with an IBM i System? Do you want to test compatibility with old AS400 and iSeries applications? Do you want to fiddle with IBM i? Try pub400.com – the famous public IBM i server for ! PUB400 is the successor of PUB1 – the worlds famous public AS/400 system with

Read More

What is the best IBMi (AS400) 5250 Terminal Emulator? The IBM i System (aka i5 aka iSeries aka AS/400) uses something called 5250 to stream its data to a terminal, often called a green screen. You’ve seen this clunk old terminals in black and white scifi movies – well we still use them. Kind of.

Read More

SQL Tables with Indexes and Views are faster than DDS Phsyicals and Logicals. #HONEST SQL is a wonderful beast for quickly getting data from huge tables (aka Files). The trouble with SQL is that it’s so very simple to use; programmers get lazy and sometimes forget to do the analysis to make it as simple

Read More

I installed the first Technology Preview (aka Beta) for the new version of IBM i Access (aka Client Access) a few months ago. I really liked it, but was working on a clients project which had different standards for TN5250 and a few other things. So, to align with my team mates I worked with

Read More

TURNOVER TUTORIAL No, I will not be teaching you how to bake a #APPLETURNOVER We will be delving into the slightly less delicious world of software change management for RPG Programmers and IBM i Software Developers. I’ve been working on a freelance gig for some time now and the client uses Turnover (by Softlanding /

Read More

IBM Rational Developer (RDi) is good but bloody expensive! 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

Read More

EXTPRC – External Procedures Question: How do I promote External Procedure using Turnover and get them to automatically *REPLACE on the destination machine? Answer: Like this! The problem here, is that SQL Stored Procedures have no equivalent of *REPLACE on the CREATE PROCEDURE statement! That’s easy – “just add a Drop to line one of the

Read More

Install Turnover V100 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! Follow these steps to load the T100INST installation library. Each step is explained in detail in the

Read More

RPG CODE EXAMPLE – “Write to joblog” in RPG with Qp0zLprintf Write to joblog lets us send messages from inside a running RPG program. It’s simple using one of IBM’s API’s – Qp0zLprintf Qp0zLprintf() — Print Formatted Job Log DataThe Qp0zLprintf () function prints user data specified by format-string as an information message type to the

Read More