Author: Andy Youens
-
DB2 Field Procedures
A few years ago, DB2 for i introduced a new feature that can be used to apply security/encryption to our columns within our database. This enhancement is called Field Procedures, or FieldProcs throughout this article. DB2 FieldProcs have been around since 7.1 of IBM i in April 2010. Before FieldProcs, it was common to see…
-
DB2 Row and Column Access Control
Introduction DB2 for i has a fantastic feature that is fairly new, Row and Column Access Control, or RCAC, for ease. This feature has been around since 7.2 of IBM i in April 2014, but doesn’t get a lot of exposure, so hence my interpretation of how it works. It is a method of controlling…
-
RPG 2017 Updates
During the latest round of IBM i Technology Refreshes, TR2 for version 7.3 and TR6 for version 7.2 enhancement, IBM also introduced three enrichments for RPG. These changes will be released as individual PTFs, around the April 2017 timespan, as with the Technology Refreshes. Let us take a look at these. These are: Nested data-structures…
-
Application Runtime Expert – Worth a Look?
IBM recently announced that their product, Application Runtime Expert (ARE) for IBM I, is now free of charge, along with a host of other products. The IBM announcement can be found here if you are interested. ARE is a licensed program, 5733ARE, which will work on any IBM i Version 6 or above. It was…
-
RPG – What’s New in 7.3
As you probably know, IBM released 7.3 of the IBM i operating system in April 2016. So now it has been over six months since the new release, let us take a look at what has changed in RPG for this release. Remember that SEU has not been updated since Version 6.1 way back…
-
RDi & IFS Local Source – Worth a Look?
Introduction. As I’m sure you know, Rational Developer for IBM i was enhanced to Version 9.5.1 recently. This update gave us the ability to store our source members, RPG, CL etc. on the IFS and to have the ability to store a local copy on our PCs. This is not to be confused with the…
-
Git – A Free SCM?
In my previous article I gave you an insight into the new open source editor Orion on the IBM i. If you haven’t yet read my Orion PowerWire article, it can be found here. As promised in that article I said I would now move on to Git, which is closely integrated with Orion, and…
-
Orion – An RDi Alternative?
Introduction – Are you not yet using RDi for your RPG development, but are fed up with SEU lagging behind in releases and complaining of syntax errors when using the latest programming features? Then maybe Orion is for you. In this article, I would like to run you through a new addition to IBMs open…
-
Time Travelling with DB2 for i – The Follow Up
Introduction In my last article, on Temporal Tables for DB2 for i, which can be found here, I gave a quick insight on how easy it was to create and report on time travelling queries. Since this time, I gave the first workshop on Temporal Tables at the highly successful International i Power 2016 conference…
-
It’s about time! – Time Travelling with DB2 for i
Introduction – In this article, I want to run though a great new feature of DB2 that was released as part of the Version 7.3 announcements last month. As the title of this article states ‘It’s about time’! IBM introduced a new feature within the database called temporal support. So, what is temporal support? Temporal…
-
Using PHP and RPG to Communicate Together With DataQueues
Continuing my articles about PHP and RPG communicating together, this time I will show how these two languages can talk with each other using data queues. If you missed the other parts in this series, you can find them here. Part 1 Part 2 DataQueues If you know all about dataqueues, you can skip this…
-
Using PHP and RPG to Communicate Together Part 2
This is the second part to my article about PHP and RPG communicating together. If you missed the first part, it can be found here. Last time we discussed PHP calling, and using, the power of RPG. This time let us switch things around and show you how easy it is for RPG, or any…