• Guru: Fall Brings New RPG Features, Part 3

  January 18, 2021 Jon Paris

  In my previous tips (see Related Stories below), I covered the new BIFs and op-code options added with this release. This time I’m going to discuss a couple of new compiler options that focus on the conversion of character data to numeric.

  While you may not have needed these capabilities to date, it is highly likely that you will in the near future. Why? Because of the rapid growth in the use of web services in the IBM i world. I don’t think I have talked to a single client in the last 12 months who was not already providing …

  Read more

• Guru: Fall Brings New RPG Features, Part 2

  January 11, 2021 Jon Paris

  In my previous tip I outlined some of the new features added to RPG with the Fall 2020 release. In this and the following tip I will be covering the features that I ran out of space for in that first one.

  This time I will cover the new FOR-EACH loop construct. I have wanted this in RPG ever since encountering it in PHP. Simply put, it automatically iterates through an array, “serving up” one element at a time. When I say “an array” I mean any kind of array, including data structure arrays, dynamic arrays and even the new …

  Read more

• Guru: SQL and QTEMP

  January 4, 2021 Ted Holt

  Hey, Ted.

  For many years IBM i developers, operators, and others have taken advantage of an operating system feature called the QTEMP library. Through the years you have referenced it various times in IT Jungle as a useful feature of IBM i. I recently read an article in which a respected IBM expert from the Rochester lab services team told people not to use the QTEMP library when working in SQL. It would be very interesting if you could dive into this topic and explain when/if there is still a time and place for QTEMP. I think a lot of …

  Read more

• Guru: Success Requires Many Teachers

  December 14, 2020 Ted Holt

  I am not a “super programmer”- if such a thing even exists. I am not a genius, nor am I a guru. I’m not an expert. Whatever success I have had as a computer programmer these years, I attribute to a very few causes. I would like to end this year by writing about two of them.

  Number 1: I have learned, often the hard way, how to keep myself out of trouble. My code is dull and bland and boring, and I like it that way. I strive to make my code straightforward, honest, and so easy to understand …

  Read more

• Guru: Fall Brings New RPG Features

  December 7, 2020 Jon Paris

  In this time of pandemic we could all do with a little cheering up. So “Santa” Barbara (a.k.a. Barbara Morris) and the elves at the IBM Toronto Lab have delivered an early Christmas present. Available now via PTF for 7.3 and 7.4, there are some real gems in these latest RPG enhancements.

  For the most part, these enhancements assist in improving code readability. That is to say that they are not giving us completely new functionality in the way that (say) Open Access or DATA-INTO did. Rather they give us better, clearer ways of doing things. They have an additional …

  Read more

• Guru: SQL Writes CL

  November 30, 2020 Ted Holt

  SQL is the one tool I cannot work without. Take it away from me and I’ll start driving a truck for a living. Naturally I’m eager to find more ways to make SQL work for me. Today I’d like to share how I recently used SQL to write a huge CL command for me. This is a technique that’s good to know.

  My challenge was to copy all of the several hundred physical data files in a library to a save file so that those files could be loaded onto another IBM i system. The Save Library (SAVLIB) command was …

  Read more

• Guru: RDi V9.6, Part 10 – Debugger Enhancements

  November 16, 2020 Susan Gantner

  Here I go again – more enhancements to talk about that have come about in RDi V9.6. This time, it’s the debugger that has been enhanced. The 9.6.0.7 fix pack included some new goodies for the debugger.

  Both of the enhanced features were popular Requests for Enhancement (RFEs) — the ability to display very large variable values and the addition of a condition to Service Entry Points (SEPs). These are further proof that the RFE process works. If you haven’t visited the RFE site to vote for your favorite suggested features for RDi, do it now. . . or maybe …

  Read more

• Guru: Manage PTFs With The Administration Runtime Expert

  November 9, 2020 Dawn May

  This fourth article in my series on using the Administration Runtime Expert (ARE) reviews how ARE is used to manage PTFs. This article assumes you have already learned the basics of how to use ARE from the prior articles.

  PTF management with ARE features these key functions:

  • Check your installed group PTF levels compared to the latest levels available from IBM
  • Verify consistent PTF levels installed across multiple partitions
  • Distribute PTF images to endpoint systems
  • Optionally load and apply PTFs

  The ARE Template Editor provides the interface to define your templates for PTF management.

  

  Start by determining what type of …

  Read more

• Guru: SQL and Expanding Subfiles

  October 26, 2020 Ted Holt

  I’ve heard it said on more than one occasion that SQL does not work as well as record-level access (RLA) when loading subfiles. I understand why people feel that way. They’re usually thinking about repositioning to a key value, and there is no SETLL (Set Lower Limit) op code in an SQL cursor.

  Yet I think SQL is better, and today I’d like to share one case that I think presents a good illustration. I had in mind the expanding subfile. There’s a parallel between the two. Consider:

  • Every time you clear the subfile, you open a new cursor.
  • Every

  …

  Read more

• Guru: Concerning The Stepping-On Of Feet

  October 19, 2020 Ted Holt

  It has come to my attention that once again I did not tell the truth, the whole truth, and nothing but the truth. In Three Suboptimal I/O Practices, I said that a simple SELECT INTO was preferable to a cursor that fetches one row. It turns out that there is at least one situation in which SELECT INTO will not serve the purpose, and one has no choice but to use a cursor that fetches one row.

  The situation is this: the program must lock the fetched row for update. Despite its power and simplicity, SELECT INTO cannot lock …

  Read more

Previous Articles Next Articles