Skip to main content

Sort by
Articles

Use Cases for SQL’s CASE statement

Rick Flagler

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 […]

Podcasts

Rudi Van Helvoirt on COVID-19 and the Future of SQL Programming

Paul Tuohy

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 […]

Articles

IBM i New Navigator

Dawn May

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, […]

Articles

Integration Station: Announcing IBM i 7.4 TR5

Brianna Boecker

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

Articles

Using the New SQL HTTP Functions (Part 2)

Jesse Gorzinski

September 15, 2021

In Part 1 of this series, we introduced some new HTTP functions. Indeed, they are fantastic additions to the set of IBM i Services available through SQL. Today, we will explore how they can be used to integrate indigenous IBM i technologies (such as Db2 and RPG) with open-source applications. Gluing Node.js and Db2  A community member recently asked […]

Articles

Using the New SQL HTTP Functions (Part 1 of 2)

Jesse Gorzinski

September 8, 2021

As I’ve mentioned in past ramblings, IBM’s investment in open source extends into some of the core components of the operating system. The rich catalog of IBM i Services (sometimes called “SQL Services”) is a fantastic illustration of this concept. The data queue services, for instance, provide an integration point between database activity and Apache Camel. The JSON […]

Articles

Ditch DSPLOG—History Log Info Is Superior

Dawn May

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 […]

Articles

Basics of Using a Stored Procedure With Db2 Web Query for i Version 2.3

Rick Flagler

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 […]

Articles

Consolidate SQL Educational Resources With the SQL Tutor

Dawn May

June 8, 2021

Developers often use SQL to access data in Db2 for i. With the ever-increasing number of IBM i Services, system administrators have a need to learn SQL as well. Regardless of whether you are new to SQL, or an experienced SQL developer, there is always more learn. A relatively new resource, the SQL Tutor, is available […]

Articles

IBM i Gets a Refresh, Increasing Automation and Storage Options

Dava Stewart

April 20, 2021

The latest round of IBM i technology refreshes (TRs) provides enhancements to offerings, services and hardware. On Tuesday, April 13, IBM announced the latest round of OS TRs—IBM i 7.4 TR4 and 7.3 TR10. These TRs demonstrate a commitment to IBM i services, showcase a continuing push toward automation and represent a heavy investment in […]

Key Enterprises LLC is committed to ensuring digital accessibility for techchannel.com for people with disabilities. We are continually improving the user experience for everyone, and applying the relevant accessibility standards.