• These POWERUp Sessions Are About the Recent IBM i Announcement

  May 15, 2019 Alex Woodie

  Disneyland didn’t complete construction of Star Wars Galaxy’s Edge in time for next week’s POWERUp conference. But luckily for you, IBM did finalize its IBM i announcement soon enough for COMMON’s annual extravaganza, making next week’s show in Anaheim, California, a great chance for you to learn about the new releases of the operating system, including IBM i 7.4 and 7.3 TR6.

  According to COMMON’s online session guide, there are at least 16 sessions at POWERUp 19 having to do with IBM i 7.4, IBM i 7.3 Technology Refresh 6 (TR6), or the new software that will arrive with …

  Read more

• IBM Bolsters RPG And COBOL Development

  May 13, 2019 Alex Woodie

  Amid the many and varied enhancements that IBM rolled out last month for its IBM i operating system was a collection of improvements for its core development tooling, including the Eclipse-based Rational Developer for i (RDi) as well as Rational Development Studio for i, which contains the RPG and COBOL compilers.

  Let’s start with the RPG and COBOL compilers in Rational Development Studio for i, since updates to these strategic pieces are more infrequent than the updates to RDi, which shares a common base with integrated development environments (IDEs) for other operating systems and therefore updated more frequently.

  The biggest …

  Read more

• Guru: Emulate Control Break Reporting With DB2 For i SQL

  May 13, 2019 Michael Sansoterra

  When generating ad hoc user reports, it’s often the case that developers don’t have the time or luxury to write a high-level language program or to use a reporting tool such as DB2 Web Query or Crystal Reports to format the data appropriately. But when a user is given a raw dump of a SELECT statement’s result set in Excel, it can be quite ugly to wade through and format.

  The user may have to do things like add total rows or remove duplicate values, which can be quite time consuming. Thankfully, DB2 for i SQL offers a way to …

  Read more

• Does Db2 Mirror Kill The Market for Third Party HA?

  May 6, 2019 Alex Woodie

  IBM launched Db2 Mirror for i two weeks ago to great acclaim, as the clustering technology puts IBM i on par with how most other major systems provide continuous availability. But will Db2 Mirror destroy the platform’s heritage of high availability solutions? IT Jungle asked IBM and the biggest providers of logical replication solutions, and the answer is no. Here’s why.

  The first thing to understand about Db2 Mirror is that, at heart, it’s a database clustering technology. IBM figured out a way to make a single instance of Db2 for i run on two separate systems, in an active-active …

  Read more

• Guru: Open Access To The Rescue – The Next Step

  May 6, 2019 Jon Paris

  I recently wrote a tip on using an Open Access handler to enable the creation of flat files in the IFS. In that version of the handler I generated a generic file name and used hard-coded record delimiters and code page settings. I mentioned at the time that I would normally supply these values at run time. In this follow-on tip I describe how the handler can be modified to use the Open Access User Parameter to facilitate this.

  The User Parameter is simply specified as a second parameter to the HANDLER keyword. It can be a simple variable or, …

  Read more

• Club Alan: Seiden Signs Liam, Corners Youth Market

  April 29, 2019 Alex Woodie

  The Seiden Group solidified its position in the futures market this month by signing the young British-born IBM i phenom Liam Allan to a long-term employment contact that will see him involved in training and open source development work, among other activities.

  Allan’s signing with Seiden Group is a reunion of sorts for Allan and Alan Seiden, the company’s founder and CEO. Allan credits Seiden with roping him into the IBM i gig via Club Seiden, an intersectionalist group devoted to exploring emerging digital and social connections involving the IBM i operating system and the open source ecosystem.

  “The …

  Read more

• IBM Brings Active-Active Mirroring Into Db2 For i Database

  April 24, 2019 Timothy Prickett Morgan

  As a platform that is approaching 40 years of deployment within enterprises that can’t afford downtime with their mission critical systems – that’s counting the System/38 as well as the AS/400 and its follow-ons as part of the same continuum – it is no surprise at all that IBM midrange systems running RPG and COBOL had some of the most sophisticated – and perhaps the only application-centric – clustering software ever developed.

  Concurrent with the launch of IBM i 7.4 this week, Big Blue is rolling out a new kind of database clustering, which is called Db2 Mirror, that is …

  Read more

• Guru: Preamble Comments

  April 15, 2019 Chris Ringer

  Do you remember what you ate for lunch two days ago? If you’re like me, you had to think about it for a minute before answering. Now imagine trying to recall the detailed requirements of a few programs you wrote a year ago so you can modify them for a new project. Or better yet, what if someone else like a retired employee or a traveling contractor coded these programs? At this point you may become very dependent on any comments they left in the code.

  It’s been said that any time spent commenting on your code now might save …

  Read more

• RTPA Looking For A Few Good Software Reviewers

  April 8, 2019 Timothy Prickett Morgan

  Throughout the six decades of commercial computing, one thing has been universally true. Every good application development or system management tool, from the simplest debuggers all the way up to complex DevOps systems that can absorb multiple continuous streams of new code being mashed up against old code without making a mess of things, got its start because some programmer or administrator was so annoyed at how something worked – or more precisely didn’t work – that he or she created a new tool that did the job a whole lot better.

  This is precisely the beginning story of Real-Time …

  Read more

• Guru: Dealing With RPG Errors and Embedded SQL

  April 8, 2019 Ted Holt

  Hey, Ted! I’m having trouble using some of the new techniques I learned at the RPG and DB2 Summit. Below is a screen shot of a program I am writing. I cannot figure out why the compiler doesn’t like it. Can you see anything that would be causing the declarations to fail?

  — Mike

  I glanced over Mike’s code and noticed that he used a correlation name in the SELECT and WHERE clauses, but did not define that correlation name for any of the tables, like this:

  SELECT x.onefield, x.twofield, x.redfield, x.bluefield
  FROM MYTABLE
  WHERE x.onefield = :TestValue;
  

  He …

  Read more

Previous Articles