TechChannel E-book: Streamline Your Modernization Strategies With Open Source and SQL With Db2 for i
December 6, 2021
Modernization strategies come in many forms—each with a unique blend of cost, risk and value. But some strategies are better than others, depending on your organizational needs. Some organizations still have hesitations about adopting the most effective modernization strategies—such as establishing a virtual layer of SQL views within physical data models or leveraging open-source technologies. […]
ArticlesActive Prestart Jobs in New Navigator
October 13, 2021
With New Nav, you have a graphical user interface and you no longer need to craft your own queries to get at the data. Learn the benefits from Dawn May here.
ArticlesUse Cases for SQL’s CASE statement
October 11, 2021
Have you ever wanted to conditionally do some processing in an SQL SELECT statement? I‘m sure you have, as this isn’t really an unusual situation. In RPG and other languages, we have the IF or SELECT statements for this. In an SQL procedure, you can also use IF. But in a SELECT statement, the way […]
PodcastsRudi Van Helvoirt on COVID-19 and the Future of SQL Programming
October 4, 2021
Paul Tuohy: Hi everyone and welcome to another iTalk with Tuohy. I'm delighted to be joined today by, I think long overdue iTalk with my friend, my colleague and IBM Champion Rudi Van Helvoirt. Rudi, how are you? Rudi Van Helvoirt: I'm fine. Paul: Did I kill your name? Was I close enough in the […]
ArticlesIBM i New Navigator
September 21, 2021
One of the most exciting functions is Navigator for i – new version!, which IBM refers to as “New Nav.” The existing Navigator web console is now called the “Heritage Version.” The IBM announcement included the following text: “Navigator for i has been completely reimagined from the ground up. Leveraging the very latest in web technology, […]
Integration Station: Announcing IBM i 7.4 TR5
September 16, 2021
IBM i 7.4 TR5 offers an all-new web interface for IBM Navigator for I, new HTTP SQL functions, open-source inclusion and more
ArticlesUsing the New SQL HTTP Functions (Part 2)
September 15, 2021
How to use the new SQL HTTP functions to integrate indigenous IBM i technologies (such as Db2 and RPG) with open-source applications
ArticlesUsing the New SQL HTTP Functions (Part 1 of 2)
September 8, 2021
A new and improved set of HTTP functions have been added to Db2 for i. Get the details from Jesse Gorzinski and Scott Forstie here.
ArticlesDitch DSPLOG—History Log Info Is Superior
September 7, 2021
The history log is a great repository of messages on your IBM i partition; all messages sent to QSYSOPR, QSYSMSG and QCFGMSGQ are also sent to the history log. There are many functions that log additional messages to the history log, although they may not send those messages to the system operator message queue. Mining […]
ArticlesBasics of Using a Stored Procedure With Db2 Web Query for i Version 2.3
August 2, 2021
The most recent releases of Db2 Web Query introduced interface enhancements to the Home page, metadata management and report design. This article will discuss some of these changes in the context of illustrating using an SQL stored procedure (SP) as a data source for one or more Web Query reports. The procedure presents data for […]