• IBM Unveils New and Improved IBM i Services

  April 14, 2021 Alex Woodie

  If you like IBM i Services — those SQL-based methods for executing a range of tasks in the operating system — then you’re in luck, because IBM has included a handful of new and improved IBM i Services in the Technology Refreshes (TRs) for IBM i 7.4 and 7.3, which were unveiled yesterday and ship this Friday.

  IBM has developed an affinity for IBM i Services in the last few releases of the operating system. And why not? Users seem to like having a SQL-based alternative to CL commands and APIs. And since the IBM i Services are so easily …

  Read more

• Big Blue Unveils Spring 2021 IBM i Technology Refreshes

  April 12, 2021 Alex Woodie

  IBM tomorrow will announce the latest round of Technology Refreshes (TRs) for the current versions of the operating systems. With IBM i 7.4 TR4 and 7.3 TR10, IBM is focusing its efforts on extending automation across various components of the operating system, including the database, security, and high availability. But a surprise also awaits IBM i enthusiasts who are visually inclined.

  IBM gave IT Jungle a preview of the announcements that will go public tomorrow, and (very kindly) gave us permission to cover them in today’s issue of The Four Hundred. That means that the announcement materials will not …

  Read more

• Oracle Versus Rimini Slogs On In Second Decade

  April 5, 2021 Alex Woodie

  The lawsuit that keeps on giving, Oracle Versus Rimini Street, is generating news again, as the two companies continue to duke it out in federal court. But the battle spilled out into the streets with a pair of dueling press releases issued April 1 that had us wondering if it was all a joke. It wasn’t.

  The last time we visited Oracle Versus Rimini Street was two years ago, when the Supreme Court ruled 9-0 in favor of Rimini on the issue of costs. After a jury decided that Rimini was violating Oracle’s copyright in its third-party software support business …

  Read more

• OpenShift Provides One Path To IBM i Modernization

  March 29, 2021 Alex Woodie

  The crown jewel in IBM’s $34 billion acquisition of Red Hat arguably is OpenShift, which is a Kubernetes-based container management system for running “cloud-native” applications. While it’s unlikely OpenShift will ever integrate directly with IBM i and its applications, IBM has high hopes the software will help usher in a new wave of application modernization and innovation among IBM i customers.

  IBM Power engineer Joe Cropper laid out the case for IBM i shops to get going with OpenShift two weeks ago during the IBM i Futures conference, which was hosted by COMMON. Cropper, you will remember, made a …

  Read more

• Low-Code API Development Gets A Boost From Profound

  March 10, 2021 Alex Woodie

  Profound Logic last week launched Profound API, a new product designed to enable the development and management of RESTful Web services with a minimal amount of coding. The browser-based product works with IBM i programs and data, as well as assets located off the box, and is designed to enable even entry-level IT professionals to get into the API game.

  Application programming interfaces (APIs) have been around for decades. Nearly every developer will call or expose an API at some point in their lives. But APIs have been gaining new momentum lately as a critical layer enabling the future of …

  Read more

• Matillion Founder Recounts Midrange Roots

  February 24, 2021 Alex Woodie

  In the mad rush to build data warehouses in the cloud, there’s one group that’s doing surprisingly well: ETL tool providers. Despite the sophistication of today’s AI and analytic endeavors, ETL tools are a critical link in the chain to the cloud. And one of the up-and-coming vendors in this space is Matillion, which last week raised $100 million in venture capital.

  Matillion was founded in 2011 to help companies build cloud data warehouses. The Anglo-American firm developed expertise in taking companies’ corporate data from on-premise systems and building data warehouse on emerging cloud systems, such as Amazon Web Services’ …

  Read more

• Guru: Prompting Stored Procedures

  February 22, 2021 Paul Tuohy

  In this tip I would like to touch on two items, in relation to stored procedures, that may have escaped your notice: prompting stored procedures and/or parameters (in Run SQL Scripts) and passing parameters by name.

  I must admit that, as I have gotten older, my ability to remember the names and parameters for stored procedures has, shall we say, decreased. At this stage, I am lucky if I can remember which library/schema one of my stored procedures is in!

  A case in point. I recently received an e-mail about a stored procedure I had written about (back in 2015) …

  Read more

• 2021 Predictions for IBM i, Part 1

  January 13, 2021 Alex Woodie

  With an eventful 2020 thankfully in the rearview mirror, it’s time to start thinking about what 2021 might have in store for us. The IBM i community, like most of the world, could use a little bit of hope at the moment. We asked IBM i community leaders to deliver predictions, and they responded.

  Liam Allan, who is a consultant at Seiden Group and the creator of ILE Editor, has a couple of predictions for IT Jungle.

  “My focus is mainly software. I do still predict Node.js gaining traction on IBM i,” Allan writes. “The tooling is really …

  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

• MariaDB Now Available Via RPM

  December 7, 2020 Alex Woodie

  When it comes to databases for the IBM i community, Db2 for i is, and always be, number one. But there’s no reason to limit yourself to just one database, and now IBM is making it easier for IBM i shops to get their hands on MariaDB, which could be the number two database on the platform.

  MariaDB is an open source relational database that is a fork of MySQL. MySQL, of course, has been supported on the IBM i server for many years. But following Oracle’s acquisition of Sun Microsystems, which had acquired the company that developed MySQL, …

  Read more

Previous Articles Next Articles