• Guru: What Do People Have Against Timestamps?

  August 3, 2020 Ted Holt

  In my work I often see database tables and physical files with related date and time fields (columns). By related, I mean that the two fields together indicate a certain time on a certain date for a certain event. I have found these date/time pairs to be difficult to work with at times, so much so that I have come to prefer timestamps.

  I wonder why database architects (I use the term loosely) specify separate date and time fields rather than a timestamp. Having done no scientific survey, I can only guess. I suspect that many tables date back …

  Read more

• Guru: Creating PDF Documents With Python

  July 27, 2020 Mike Larsen

  I’m often asked to create reports for my business partners. The format of the report depends on who made the request. If the financial team made the request, I may produce an Excel file. The CEO may want to report quarterly sales to their shareholders. In that case, I may produce a PDF using the company letterhead.

  In a prior article, I showed how to create Excel files using Db2 tables. Now I’m going to show how to create PDF documents using Db2 tables.

  This story contains code, which you can download here.

  I always start by making …

  Read more

• Guru: Dynamic Arrays Come To RPG

  July 20, 2020 Jon Paris

  Some 12 months ago, when the 7.4 release was announced, I wrote the Guru Tip “7.4 Brings New RPG Goodies” describing the features of 7.4 that were also available on 7.3. I said at the time that I would return later to discuss the 7.4-only features. So now that a significant number of shops have access to 7.4 that time has arrived.

  Dynamic arrays are the answer to the perennial programmer question: “Just how big do I need to make this array?” In my experience it doesn’t actually matter how big you make it, at some point down the road …

  Read more

• Guru: The Case for Mixed-Case Procedure Names

  July 14, 2020 Paul Tuohy

  Using mixed case makes source code easier to read and easier to debug. I programmed in all upper case for many, many years, so I don’t recoil in horror when I see something in all uppercase. However, it’s a bit more difficult for developers who aren’t quite as long in the tooth as I am. To them, all uppercase is pretty abhorrent and bad (and I don’t mean bad as in good).

  There is a potential case issue with subprocedure names: there are at least three places on the system where the system shows subprocedure names in uppercase, regardless of …

  Read more

• Guru: RDi V9.6, Part 9 – RDi Helps with Refactoring Code into Procedures

  July 6, 2020 Susan Gantner

  I’m guessing that you have some RPG code in your shop that’s desperately in need of some refactoring. I have yet to visit an RPG one that wasn’t in that position. If by chance you don’t know what I mean by “refactoring” or why you may need it, I highly recommend that you read Ted Holt’s excellent series of Guru tips on refactoring RPG. I’ve included links to those tips in the Related Stories section below.

  I was inspired to go back and review the entire series after I attended Ted’s session Refactoring RPG: What, Why & How at an …

  Read more

• Guru: Use The Administration Runtime Expert To Validate Your System Configuration

  June 22, 2020 Dawn May

  Using the Administration Runtime Expert (ARE) to validate system configuration settings is an easy way to confirm configuration values are set the way you want them to be. You can use ARE to ensure these system configuration settings are consistent across multiple IBM i partitions or to verify settings have not changed on an individual partition. In this second in a series of articles on ARE, we’ll walk through the steps to set up a basic template to validate system configuration settings.

  The first step is to identify what system configuration attributes you want to make sure are consistent or …

  Read more

• Guru: Graphical Debugging Through ACS

  June 8, 2020 Ted Holt

  ACS (IBM i Access Client Solutions) keeps getting better and better. I can’t stay up-to-date with the latest releases of all the software I use, but I do everything I can to keep up-to-date with ACS. One of the handiest of the relatively most recent releases is the ability to access IBM i Debugger through Run SQL Scripts. If you haven’t tried IBM i Debugger, you’re missing out.

  IBM i Debugger (a.k.a. System Debugger) is part of the IBM Toolkit for Java. It’s graphical, and it makes the green-screen debugger (STRDBG) look like something built by cavemen. To show you …

  Read more

• Guru: RDi V9.6, Part 8 – Better Ways To Copy Members, Manage LIBLs, and Find Preferences

  May 18, 2020 Susan Gantner

  If my crystal ball had told me just how many RDi V9.6 fix packs there would be and, more importantly, how many great new features would be added, I might have thought differently about starting a numbered series! Looks like I may well make it into double digits. But I’m not complaining. RDi has always been a great tool, and the pace of significant new functionality added since late 2017, when V9.6 first appeared, has reached new heights.

  This tip covers some of the features added in V9.6.0.7. Yes, I still have some catching up to do since 9.6.0.8 recently …

  Read more

• Guru: RDi V9.6 Part 7 – Zoom in, Know Where You Are, Refactor Constants and More

  May 11, 2020 Susan Gantner

  RDi enhancements just keep coming. Since my last installment in this series on V9.6 there have been more fix packs and quite a few new features. Here in part 7 I’ll cover refactoring character constants, two ways for RDi to indicate “you are here”, and a small but really useful way to zoom in on your code. Plus a small bonus item for those who do their compiles in batch.

  You Are Here!

  Two new features were added in 9.6.0.6 that act a bit like those “you are here” indications on maps. When editing RPG code, it tells you if …

  Read more

• Guru: Calling RPG Programs From Python, Part 2

  April 27, 2020 Mike Larsen

  In Calling RPG Programs From Python, Part 1, I showed how to call an RPG program from a Python script passing single string parameters as input and output. In the second part of this series, I’ll make the process a little more robust by passing a data structure to the RPG program.

  The first part of the Python script (shown in the first piece of code below) imports the itoolkit modules and assigns them to local names. Next, I set up the first command that adds a library list entry to where the RPG object resides.

  from itoolkit import 

  …

  Read more

Previous Articles Next Articles