• Thoroughly Modern: Practical Ways IBM i Developers Can Use AI Today

  December 4, 2023 Scott Gingerysty

  This October at COMMON’s NAViGATE Conference, I presented a session about practical ways that IBM i developers can use AI in their day-to-day development practices. We discussed how you can streamline and optimize the development process, improve coding velocity, enhance code hygiene, testing and documentation, and we also looked at some of the caveats. After connecting with the folks at COMMON – and seeing their enthusiasm – I felt inspired to share these examples with the IT Jungle community.

  So, why AI for developers? AI offers a transformative toolkit that streamlines learning and amplifies creative problem-solving. Through machine learning algorithms, …

  Read more

• Guru: Partitioning Result Sets Using SQL

  November 27, 2023 Mike Larsen

  While working on a project recently, I needed to retrieve attributes of an item. While that sounds like a simple task, there was a twist. While reviewing the contents of the item master table, I noticed there could be multiple rows for the same item and each row was active and valid from a business perspective.

  I won’t get into the business end of it, but my goal was to return the most recent iteration of the item for further processing in the program. After doing some research and trying some potential solutions, I came across the SQL partition by …

  Read more

• IBM i Shops Have Alternatives to Db2 Web Query

  November 15, 2023 Alex Woodie

  The sudden demise of Db2 Web Query has sent customers looking for alternatives. The good news is that IBM i software vendors offer a number of pre-built solutions that can fit the bill.

  Here are some potential business intelligence tools from vendors that could serve as replacements to Db2 Web Query. We’ll take a look at open source alternatives in a future article.

  Cozzi Research SQL World

  Cozzi Research develops two query tools for IBM i, including SQL iQuery and SQL Tools, and bundles them both in a single product called SQL World.

  Cozzi positions SQL iQuery as a native …

  Read more

• What’s New with Db2 Mirror, PowerHA, and BRMS

  November 8, 2023 Alex Woodie

  There’s something for everyone in the new releases of IBM i that IBM will be shipping later this month. For administrators who revel in having well-run high availability, continuous availability, and tape backups, the new releases will not disappoint.

  The most substantial enhancements appear to have been saved for Db2 Mirror for i, which is IBM’s continuous availability solution for IBM i. The new management and monitoring features should bring some major improvements to how customers interact with the product.

  Some of the biggest changes are due to the addition of the new “Health Center” component to the Db2 Mirror …

  Read more

• IBM, TIBCO Remain Mum on Db2 Web Query Future

  November 1, 2023 Alex Woodie

  While Db2 Web Query users are left hanging in the wind without any official way forward to protect their investments in the product, IBM and TIBCO have yet to make any public announcements about how to support these IBM i customers moving forward.

  IBM shocked the midrange last month when it announced the sudden end of life of Db2 Web Query, the IBM i-based analytics tool that was largely based on an OEM (original equipment manufacturer) version of the WebFOCUS product originally developed by Information Builders and now owned by TIBCO.

  The October 10 announcement – the same day …

  Read more

• Guru: The Transition From Modern RPG IV To Modern SQL

  October 30, 2023 Bob Cozzi

  Seven or eight years ago I was working with a client who needed more contemporary reporting than provided by the legacy Query/400 product. Initially I looked at Db2 Web Query and realized the documentation was sparse and the tutorials for most things, even “getting started” were virtually non-existent. It was also about four times more expensive than I felt it was worth to a P05 or P10 client. I mentioned the documentation issue to the folks at IBM and they agreed. Some of it was eventually resolved, but not enough in my opinion to get the masses to replace Query/400 …

  Read more

• What the Latest ALL400s Survey Tells Us About the IBM i Community

  October 18, 2023 Alex Woodie

  What is the most popular development tool in the IBM i community? What technology exists in nearly every shop? What BI tools are in use? And what activities are sitting in the IT backlog’s of IBM i shops? These are some of the questions that ALL400s answered with the latest edition of its IBM i community survey.

  You may have heard about ALL400s as the comprehensive list of IBM i customers around the world. John Rockwell, the Florida man behind ALL400s, does his best to keep the list as updated as possible.

  In addition to the list, Rockwell has put …

  Read more

• Tech Refreshes Bring SQL-Based Services Galore For IBM i and Db2

  October 16, 2023 Alex Woodie

  With the latest Technology Refreshes, IBM unleashed another round of new and updated IBM i Services aimed simplifying life for administrators, developers, and other IBM i professionals. The company also refreshed its slate of Db2 for i Services.

  Over the past decade, IBM has been busy rejiggering how users interact with core components of the operating system. Instead of issuing traditional CL commands or working with low-level APIs, users can tap into new SQL-based IBM i services via Access Client Solutions (ACS) to accomplish the same tasks.

  Db2 for i Database Architect Scott Forstie and his team have created hundreds …

  Read more

• Fall 2023 IBM i Tech Refresh Brings Something For Everyone

  October 11, 2023 Alex Woodie

  As expected, IBM yesterday unveiled its fall Technology Refresh (TR) for IBM i, with updates starting to become available on November 17. IBM announced no new products as part of the fall 2023 TR cycle, but it did spread the love around by giving just about everybody something to cheer about in IBM i 7.5 TR3 and 7.4 TR9.

  Lots of different products that make up the IBM i environment will see some pretty meaningful enhancements with this release. If you spend a lot of time in Navigator for i or ACS, you will see new stuff. We haven’t had …

  Read more

• Guru: Search Source Code For Strings Using SQL

  October 9, 2023 Bob Cozzi

  The IBM-supplied Find String Using PDM (FNDSTRPDM) command and PDM option 25 are how most developers scan for a simple value in a list of source file members. But what if you need more? For example, what if you want to find something complex, such as the field named “CUST” but not the field named “CUSTNAME” “CUSTOMER” or “CUSTNO”? Go ahead, I’ll wait?

  While I do use FNDSTRPDM all the time, I now use the SQL READSRC (Read Source File Member) Table function more often.

  READSRC SQL UDTF

  The READSRC SQL Table function or UDTF (User-defined table function) uses an …

  Read more

Previous Articles Next Articles