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

Have you been asked to add a part number as a barcode to an existing warehouse report? Does the report currently print as an old fashioned text based spool that looks like it came from the 1980’s? Is this program written in RPG? Is the Printer file defined in DDS? If the answer to these

Read More

Jerry is a friendly chap, accomplished mechanic with great prices and swift work! It’s not often I endorse a local business but JR Mobile Mechanic in Charleston is awesome! Jerry is a thoroughly decent chap, punctual, professional, did the job with minimal fuss and cleaned everything up afterwards. Great job Jerry — you have a

Read More

I’m in the final stages of a fun project writing web-services to interface INFOR System21 (on an IBM i aka AS400) with ACSIS Visitrack (on Windows Server), we are consuming (receiving) and serving (sending) all data in a standard alphameric layout But… as any RPG programmer will know… the conversion between alpha to numeric is

Read More

Over at DRUMS THE WORD a new kid is on the block; the new kid is the old kid, but with a new coat on The King is dead – long live the King! Rob Litten and I have been working together over the last six months, between him in Hampshire (England) and me in

Read More

Thanks to Mr Aaron Bartell for this excellent article on using GIT for controlling source code changes on IBM i. I’ve been doing this for a while on source code for PROJEX4i and have kept meaning to write a little blog about it. Aaron’s article nicely touches on the high-level concepts of GIT, it’s ease

Read More

Over the last year I’ve been using SQL more and more for all my RPG file access needs. The more I use it the more I like it and I’m building my own little set of reusable components and settled in with some naming standard that work for me. I thought I would enter them

Read More

Display, View, Debug IBM i Data Queues  Data Queues are a common object type in many applications on IBM i Systems: They offer an easy way to queue up data to be read and processed. Easy to load, easy to read, and an easy way to handle sequential data. The only thing that I really

Read More