• Guru: Phonetic Functions In SQL, Part 1

  September 17, 2018 Paul Tuohy

  In my next two articles I am going to discuss the use of phonetic functions in SQL. You can use phonetic functions to select or order rows based on the phonetic sound of a string as opposed to the actual characters in the string. The obvious use of phonetic functions is with names, but they can be used with any string columns.

  I must admit that this touches on one of my pet peeves — the spelling of my surname. I have lost count of the number of times I have had to spell my name two, three, or four …

  Read more

• Guru: Data-Centrism, Step Zero

  September 10, 2018 Ted Holt

  I hear a lot these days about the need for data-centric information systems. That is as it should be. The proper way to support an organization is to remove logic from application programs and put it into the database through such devices as constraints and triggers. However, before many shops can take the first step in that direction, they need to take what I call step zero.

  Step zero in data-centric computing is to remove hard-coded data values from programs and put them into the database. Just as the database manager should enforce business rules (e.g. we don’t ship to …

  Read more

• Guru: RPG Sorting and Searching, A 7.2 Update

  September 5, 2018 Susan Gantner

  Author’s Note: This is the second update I’ve done to a tip I originally wrote back in 2008. In 2010, I updated the code to use SORTA with array data structures. Here in 2018 I’m updating it once more — this time to use free-form declarations in place of the D specs, including a more obvious way to code the nested data structure used in some of the examples and references to more recent tips for handling very large arrays. The 2010 version was entitled “. . . A 7.1 Update.” I’ve renamed this one as “. . . A …

  Read more

• Guru: Handling Constraint Violations In RPG

  September 5, 2018 Paul Tuohy

  Author’s Note: The contents of this article were originally published as two separate articles – Handling Constraint Violations in RPG and Handling Constraints Revisited. The content of the article has been updated for free form RPG and some of the coding enhancements that have been introduced, into RPG, since 2009.

  Constraints have been around for a long time but apparently have not quite made it into every programmer’s tool kit. This is partly explained by the fact that implementing constraints in an existing application can be tricky, but it doesn’t explain why constraints are not used extensively in new …

  Read more

• Guru: Getting the Message, Part 2

  August 29, 2018 Paul Tuohy

  Author’s Note: This article was originally published in October 2009. Since then, I have worked on many modernization projects with many clients and, in every one of those projects, we have used some form of the contents of this (and the following) article. The content of the article has been updated for free-form RPG and some of the coding enhancements that have been introduced, into RPG, since 2009. The original articles also showed examples of direct calls to RPG subprocedures from PHP. Given that we now have many languages (Node.js, Python etc.) that interact with RPG, I changed the mechanism …

  Read more

• Guru: Make It Easy On Someone Else

  August 20, 2018 Ted Holt

  “Make it easy on yourself,” warbled Dionne Warwick when I was just a pup. That may be good advice when severing a romantic relationship, but not when programming computers. Instead of making it easy on ourselves, we who develop and support applications need to make it easy on the people we serve.

  Recently I worked on a project in which users had to enter time values into various Web pages. The original specifications stated that users would enter time values in a format we commonly use in the United States: two-digit hour, a colon, two-digit minute, a space, …

  Read more

• Latest IBM i TRs To Ship Next Month

  August 15, 2018 Alex Woodie

  IBM unveiled a pair of out-of-bound technology refreshes (TRs) for the IBM i operating system last week. In addition to supporting the new Power Systems E980 server, IBM i 7.3 TR5 and 7.2 TR9 bring a set of enhancements to the platform’s database, development tools, and the administrative interface.

  The IBM i installed base has grown accustomed to seeing operating system updates in the spring and the fall. This twice-a-year pattern has been with us, more or less, since IBM shifted to the TR approach several years ago. But IBM broke with that tradition last week when it announced that …

  Read more

• Guru: Getting The Message, Part 1

  August 1, 2018 Paul Tuohy

  Author’s Note: This article was originally published in October 2009. Since then I have worked on many modernization projects with many clients and, in every one of those projects, we have used some form of the contents of this (and the following) article. The content of the article has been updated for free form RPG and some of the coding enhancements that have been introduced, into RPG, since the original publication of this piece.

  When we look at modernizing applications (or writing new applications) one of the basic principles is to tier the application — i.e., separate the interface — …

  Read more

• More Transparency Needed For Open Source Running on IBM i

  July 25, 2018 Alex Woodie

  Open source may be the future of IBM i. It certainly seems that way at the moment. But if open source is going to soar to new heights on the platform, it will need better integration with the existing processes in place to monitor and manage the platform.

  That’s the opinion of JK Grafe, the CEO of Quad Nova Group, a Jacksonville, Florida-based IBM i consultancy that has offices up the Eastern Seaboard. By Grafe’s own admission, open source is a great thing for the platform. But the difficulty in seeing what’s actually going on with open source workloads …

  Read more

• PTC Refines Handling Of IBM i Database Logic

  July 18, 2018 Alex Woodie

  More organizations are moving business logic from RPG and COBOL programs into the DB2 for i database, which most community members agree is a good thing. The IBM i server’s core strength is its integrated a database, after all. However, when business logic moves into the database, it requires customers to rethink how they’re managing the code, which is a mantle that PTC has taken up with its Implementer software change management (SCM) tool.

  When it comes to application modernization, fancy HTML5 screens and mobile apps usually grab the spotlight. We’re often moved by the things we can see, and …

  Read more

Previous Articles