IBM i QSYS2.Services_Info and Navigator for i
May 10, 2018
The QSYS2.Services_Info service is an easy way to see all of the available services along with an example of each.
ArticlesIBM i 30th Anniversary Celebration Begins
April 2, 2018
Here we go! As I hinted in my last post, it’s time to celebrate the 30th anniversary of IBM i—and that celebration starts today, officially. We had a “preview party” of sorts at the RPG & DB2 Summit a few weeks ago, and we had a great time. Now, we get to start celebrating with […]
ArticlesPOWER9 for IBM i and the Announcement of 7.3 TR 4
February 14, 2018
Today, February 13, 2018, is announce day for the Technology Refresh 4 (TR4) of IBM i 7.3 and TR8 of IBM i 7.2. In line with our IBM i communication strategy, this blog will cover highlights of the announcement, and further information will be found starting today on the IBM i site on ibm.com, the […]
ArticlesUsing SQL Functions in a DEFINE field in Db2 Web Query for i
October 10, 2017
The capabilities provided through the use of SQL and user-defined functions brings more power to the already powerful Web Query reporting system.
ArticlesUsing BIF in Calculations Within DB2 Web Query for i
March 21, 2017
Built-in functions (BIFs) have been part of the IBM i ecosystem for years. This article examines the BIFs that are part of IBM DB2 Web Query for i.
Using Stored Procedures in DB2 Web Query for i: Part 2
February 14, 2017
A stored procedure with multiple result sets can be created in a dashboard using DB2 Web Query for i. Learn how to do more with more complex SQL.
ArticlesSQL Stored Procedure Tutorial
February 1, 2017
How to use a SQL stored procedure for data retrieval to feed a DB2 Web Query for i dashboard document.
ArticlesA Debate: DDS Versus DDL
September 1, 2008
Should you switch your DDS-defined files to DDL and replace RPG file access with embedded SQL? There's no simple answer, but a mix might be the best option.