DB2 for i Archives - Page 2 of 19

IBM Introduces Mapepire, The New Db2 For i Client

September 9, 2024 Alex Woodie

IBM has released a new client for connecting applications to the Db2 for i database. Dubbed Mapepire, the open source client is designed to be faster, lighter weight, and easier for developers to work with compared to existing ODBC and JDBC database clients, especially in cloud environments.

Building an application-side database client using existing Db2 for i’s database drivers, such as ODBC and JDBC (included in the JTOpen Java toolbox for IBM i) typically entails cramming a lot of overhead into the client component, says Liam Allan, who helps develop new open source development tooling at IBM.

“For example, jtopen …
Read more
What’s Cooking In Code For IBM i?

July 15, 2024 Alex Woodie

With IBM beginning to pull back on green screen development tools for IBM i, the importance of Code for IBM i to the IBM i development community has never been greater. The good news is that there’s a lot of development activity at the moment around the Visual Studio Code plug-in, with new features to replace some of the outgoing greenscreen functionality.

IBM announced that it was killing off some of the green screen development tools in its Application Development Toolset (ADTS) as part of its Technology Refresh (TR) for IBM i 7.4 and 7.5 in early May. Among the …
Read more
IBM i PTF Guide, Volume 26, Numbers 24 And 25

July 8, 2024 Doug Bidwell

It is Ketchup Week here at the IBM i PTF Guide, and not just because of all of the hot dogs, hamburgers, and French American fries being consumed for the Independence Day holiday here in the United States of America.

The Four Hundred has been publishing on a lighter schedule than usual, as sometimes happens during the summer months as people get some downtime, and we are catching you up on the PTFs for the IBM i stack, converging two issues of The Guide into a single one so we can get back to lock stepping it in Monday’s …
Read more
Profound Brings GenAI Tech To IBM i Apps with Profound AI

June 24, 2024 Alex Woodie

For more than 20 years, Profound Logic has been at the cutting edge of bringing the latest Web, mobile, and API technology to IBM i shops. With the launch of Profound AI, it’s now helping IBM i shops adopt the latest in user interface tech: natural language and generative AI.

GenAI has taken the world by storm since OpenAI launched ChatGPT in late 2022. Since then, nearly every large enterprise has explored the potential for using large language models (LLMs) to develop a range of GenAI products, including chatbots, autonomous agents, question-and-answering systems, and knowledge management apps.

Despite the potential …
Read more
IBM Banking on Merlin 2.0 to Goose Modern Development on IBM i

June 19, 2024 Alex Woodie

IBM last week shipped most of the new stuff unveiled in the Spring Technology Refreshes, which includes Merlin 2.0, the Web-based application development and modernization environment for IBM i. Big Blue is betting that the new and improved offering will encourage IBM i shops to (finally) begin their journey toward truly modern coding techniques.

Friday, June 14 marked the start of general availability for the majority of the features IBM is including in IBM i 7.5 TR4 and IBM i 7.4 TR10, which it announced on May 8. The version 2.0 release of Merlin – whose official IBM name …
Read more
Youthful IBM i Optimism In Fort Worth

June 3, 2024 Alex Woodie

The IBM i community showed up in force last month for COMMON’s annual conference. And they sure didn’t drive or fly to Fort Worth for the weather, which was hot and muggy. The POWERUp 2024 attendees – all 1,100 of them – came to the show to learn about the platform, which may be in the early stages of – dare we say it? – a youth moment.

First things first: the attendance number. COMMON was shooting for about 1,000, which is about where its annual spring conference has been for the better part of a decade (the fall conferences …
Read more
Database Enhancements Galore In Spring 2024 IBM i TRs

May 13, 2024 Alex Woodie

The IBM i server is a database machine at the end of the day, so it’s not surprising that the latest technology refreshes (TRs) focus heavily on enhancements to Db2 for i. From new aggregate functions for the query optimizer to new and improved SQL-based IBM i services, there’s plenty of database goodness to go around in these releases.

On May 7, IBM announced IBM i 7.5 TR4 and 7.4 TR10. You can read the announcement letters for the two releases here and here. The functionality for the two releases, which will become generally available on June 14, is …
Read more
Spring 2024 IBM i Technology Refresh Unveiled by IBM

May 8, 2024 Alex Woodie

IBM today took the wraps off the latest Technology Refresh for the IBM i platform. When IBM i 7.5 TR4 and 7.4 TR10 ship on June 14, customers will find enhancements such as Merlin version 2, new features in Navigator and ACS, security improvements, a couple of RPG enhancements, HA and DR enhancements, and a host of new SQL-based database services, among other capabilities.

In addition to new features, which we’ll get to in a second, the launch of IBM i 7.5 TR4 and 7.4 TR10 is important for an unexpected reason: It will mark the beginning of IBM’s transition …
Read more
Guru: Fooling Around With SQL And RPG

April 15, 2024 Gregory Simmons

Editor’s Note: This was originally scheduled to be published on April 1. No joke. And for a lot of complex reasons, that could not happen. But, it’s still fun, so enjoy.

I started out one morning, purely interested in having a bit of fun. Honest. In RSS within ACS, I often like to run this SQL:
```
 select *
 from json_table(
      QSYS2.HTTP_GET('https://icanhazdadjoke.com/',
              '{"header": "Accept,application/json", "sslTolerate":"true"}'),
              'lax $' columns ("joke" varchar(200) CCSID 1208)
      )
```
Okay, that was fun. This is harmless, good fun. But then I thought, what if I put this into a simple RPG program? Then I …
Read more
Precisely Streams IBM i Data Into Amazon’s New Db2 Service

April 8, 2024 Alex Woodie

Amid the torrent of news that Amazon Web Services unveiled at its re:Invent show four months ago was RDS for Db2, a new hosted relational data service based on IBM’s database. Amazon Web Services offers the Linux, Unix, and Windows (LUW) variant of Db2, but thanks to a new connector unveiled by Precisely last week, IBM i and mainframe shops have a way to replicate their data into it.

Amazon RDS is among the cloud giant’s most popular services, and likely one of the most popular IT services ever created. According to one estimate, Amazon RDS brings in $7 billion …
Read more

Previous Articles Next Articles

Content archive

Recent Posts

Subscribe

Pages

Search