In our previous blog, we talked about the things that we regarded as the highlights of 2016. As you might expect, since Application Development (AD) is our primary focus, the majority of things on our prediction/wish list for 2017 are also firmly rooted in that area.
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.
Part 1 of a two-part series: An overview of using an SQL stored procedure to create a dashboard using IBM DB2 Web Query for i.
Once again it is announcement time, with IBM i 7.3 Technology Refresh 2 and IBM i 7.2 Technology Refresh 6 being announced. As is somewhat typical for these Technology Refresh announcements, the content for both releases is quite similar. Steve Will’s blog “Announcing IBM i 7.3 TR2 & 7.2 TR6” reviews the announcement overall. I…
This might come as a bit of a surprise, but it’s announce day again. I know, I know–it doesn’t seem all that long ago that we announced IBM i 7.3 Technology Refresh 1. And it wasn’t! But this year’s “spring” announcement of IBM i 7.3 TR2 (and the accompanying 7.2 TR6) comes a little earlier…
Creating a program to retrieve the source DDS code of a physical file
Some time we need a day per day report … and we need all dates in a period of time.
We can use this simple trick to get all date, suppose next 30 days:
Here what we get (dd/mm/yy format)
We talked about regular expressions and DB2 for i some time ago … (look at SQL DB2 for i and Regular Expression) and today I stumbled upon this post … Clean phone number field with IBM DB2 for i SQL REGEXP_REPLACE. Let’s we try to clean a phone number with a simple regular expression: And this what…