April 16, 2021
April 16, 2021 | Volume 14 Issue 57
- LEAD ARTICLE: Introducing Database Triggers
- FEATURED ARTICLE: More Prototyping Stuff
- FEATURE EVENT: iAdmin Spring 2021
- NEWS HIGHLIGHT: IBM's Independent Managed Infrastructure Services Business to be Named Kyndryl
- WEBCAST LEARNING: The Biggest Mistakes in IBM i Security
- WHITE PAPER DOWNLOAD: White Paper: Node.js for Enterprise IBM i Modernization
- MC VIDEO SHOWCASE: Design an Invoice in 10 Minutes
- EVENT: i Am The Future - NEUGC Conference, May 3 - 5, 2021
Introducing Database Triggers
A trigger is a predefined event that runs automatically whenever a specified action is performed on a table. In the “smart reality” and “Internet of Things” times that we live in, it’s the database equivalent of the shower turning itself on (and at the right temperature) when you enter the bathtub. The fun part is that you can be very specific about what happens when that predefined event occurs.
By Rafael Victória-Pereira
Before getting into the details, let me just add that there are two types of triggers: those you might already be familiar with: high-level programming language (HLL) triggers, written in RPG or one of the other languages the IBM i supports natively, and SQL triggers. I’ll stick to the same guidelines followed thus far and will discuss only SQL triggers. It’s true that most of the stuff I’ll talk about can also be done in an RPG program. Sometimes, it might even be…
ChatGPT recommends a VTL for backup; LaserVault ViTL meets the challenge
More Prototyping Stuff
Last month, we looked at ILE RPG Prototyping Primer Keywords. In this second act, I want to look at two things.
First, let’s finish up with the keywords that we can apply to the prototype subfields. This will primarily be the CONST keyword.
And second, I want to take a closer look at the various cases involving the lengths of those subfields and how the relationship between the different lengths can affect the data being passed.
By David Shirey
Editor's Note: This article is excerpted from chapter 16 of 21st Century RPG: /Free, ILE, and MVC, by David Shirey.
iAdmin Spring 2021
A virtual IBM i Conference
hosted by iTech Solutions
Tuesday, April 20th - Wednesday, April 21st
Two Full Days. Live IBM i Focused Sessions. No Cost.
You’re still sick of boring "virtual events", right?
Join us for two-full days of quick-hit, no-frills sessions with real tips you can apply a schedule of IBM i experts teaching you how to do the thing they know best.
MC Press Online