• Guru: Comparing IFS Directories Using SQL

  June 19, 2023 Mike Larsen

  I use SQL almost every day at my job. It may be just a query in ACS, or it may be embedded SQL in an RPG program. A few days ago, I needed to compare the contents of one IFS directory to another. Combining a few different table functions, I was able to develop a nice solution.

  Note: The code for this article can be downloaded here.

  In this example, I have a directory that has five text files in it. I have a second directory that has three text files in it, and they are the same documents …

  Read more

• Guru: Speeding Up RPG By Reducing I/O Operations, Part 2

  June 12, 2023 Gregory Simmons

  Legacy code. Often one admits they have legacy code either with a chuckle or a wince. Nonetheless, it usually is admitted with bad connotations. We must remember though – legacy code becomes legacy code because it works. It performs its tasks day in and day out for many years and is forgotten about. Only the squeaky wheel gets the grease, right?

  The problem with this code is that, while it works, decades slip by, and technology evolves. As these decades roll along, we don’t just end up with a few programs that fit this ‘legacy code’ stereotype, we often end …

  Read more

• Guru: Binding Directory Entries

  June 5, 2023 Bob Cozzi

  I assume you’ve heard about *BNDDIR (Binding Directory) objects introduced circa 1994 with OS/400 V3R2. The infamous QC2LE binding directory is used by a huge number of RPG applications to access C runtime and unblocked MI functions such as system cvthc, cpybytes, and matmatr. You have probably seen RPG IV source code with the BNDDIR(‘QC2LE’) keyword on the header specification.

  I was one of the first developers outside of IBM to use Binding Directories for my own code. When I go back and look at my own RPG IV code created prior to mid-2007, well over 90 percent of it …

  Read more

• Guru: Find Unused Objects On IBM i Using SQL

  May 15, 2023 Bob Cozzi

  I have a client that uses SQL iQuery for nearly all “Report” type applications since SQL iQuery Version 2. They asked if they could create a report that listed all the unused objects in their user libraries. They also wanted the option to output to Excel-compatible format if desired.

  Since SQL iQuery allows you to output the results of your SELECT statements to any of its supported formats, Excel-compatible is given.

  Note: the code for this article is avaialble on GitHub at this link.

  There were a couple of approaches. I could use our other product, SQL Tools OBJECT_LIST …

  Read more

• Rimini Supports IBM i Environments with New Outsourcing Biz

  May 10, 2023 Alex Woodie

  Rimini Street’s new outsourcing business, Rimini ONE, supports IBM i application environments, the company confirmed to IT Jungle. In addition to delivering application support services for JD Edwards and SAP running on IBM i, the Las Vegas company is also offering to manage the full stack of technology upon which these ERP systems run.

  Rimini Street has provided third-party support and maintenance services for a variety of ERP systems for over a decade. You may have recalled the epic legal battle it waged with Oracle, which accused the company of stealing its intellectual property in pursuit of its …

  Read more

• Guru: Speeding Up RPG By Reducing I/O Operations, Part 1

  May 8, 2023 Gregory Simmons

  Perhaps one of the easiest ways to speed up an RPG program is to reduce the number of I/O operations it needs to perform. In this article let’s explore one simple method for moving toward dataset processing.

  Here I have a simple RPG program. Okay, admittedly, we don’t often get to write “simple” RPG programs, but for this example, I have stripped the RPG program down to just the read loop so I can demonstrate the conversion.

  1     Dcl-f AcctMstr Usage(*Input) Keyed;
  2     Dcl-pr entry ExtPgm('RPGRPT1');
  3       n Packed(3:0);
  4     End-Pr;
  
  5     Dcl-pi entry;
  6       inBranch Packed(3:0);
  7     End-pi;
  
  8     

  …

  Read more

• IBM Updates Performance Guide For Latest Power10 Iron

  May 1, 2023 Timothy Prickett Morgan

  No matter what system you are talking about, no matter what kind of applications you are running, there are always ways to squeeze more performance out of the system. The IBM i platform running atop Power10 and earlier processors is no exception, and to that end, for several years now Big Blue has provided some guidance on pushing performance with each new CPU family and as new features are added to the OS/400 and IBM i software stack.

  The latest such update, according to Steve Will, chief architect of the IBM i platform, has just been published, and you can …

  Read more

• IBM i at 35: A Walk Down Memory Lane

  April 26, 2023 Alex Woodie

  You may have heard that the IBM midrange platform is turning 35 this year. IBM has a number of events planned in honor of that milestone, culminating with a big birthday bash on June 21. IBM execs gave us a sneak peak of the festivities to come at this week’s POWERUp show in Denver, as well as a technical look back at exactly how we got here.

  The day the AS/400 launched in 1988 was notable for several reasons. IBM i CTO Steve Will, who was just starting his distinguished engineering career at IBM, recalls lots of excitement in the …

  Read more

• What the Spring 2023 TR Brings Db2 for i

  April 26, 2023 Alex Woodie

  As the beating heart of the IBM i platform, the Db2 for i database received its share of attending from Rochester for the Spring 2023 Technology Refresh. Among the goodness becoming available next week are enhancements to the database proper as well as a gaggle of new and improved IBM i services.

  One database enhancement common to both IBM i 7.5 TR2 and 7.4 TR8 is an improvement to SQL-based Web services using specific data types. The database and its SQL dialect already supported working with character large object (CLOBs) from the SQL HTTP REST functions, and provided commands for …

  Read more

• PSGi Offers Field-Level Encryption for IBM i Database

  April 19, 2023 Alex Woodie

  IBM i professionals who are concerned about the disclosure of sensitive data in their legacy applications may be interested in a new field-level encryption utility from Precision Solutions Group (PSGi). The software essentially functions as an easy-to-use wrapper for IBM’s native Field Proc for database encryption, delivering flexible data protection for legacy applications.

  PSGi has made a name for itself by providing third-party maintenance and support for aging IBM i-based ERP systems. Customers running older applications like JD Edwards World, PRMS, PRISM, and KBM rely on PSGi to keep their ERP systems running well decades after they were first created. …

  Read more

Previous Articles Next Articles