• 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

• Open Source The Path To Software Riches For IBM i

  December 2, 2020 Alex Woodie

  For what is supposed to be a proprietary platform, the IBM i server sure has a lot of open source software running on it. In recent months, it appears that the majority of new programs introduced to IBM i are open source in nature. That pattern shows no signs of changing any time soon, according to a recent report by OpenLogic.

  Open software has existed on the IBM i platform for many years. The first highly publicized dip into the open source well occurred in 2005, when IBM partnered with a company called Zend to bring its PHP runtime to …

  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

Previous Articles Next Articles