AO Advanced Modernization (RENOVATION) Workshop Session 06

DB2 for i Modernization (RENOVATION)
Constraints
Primary Keys, Unique Keys, Check Constraints and Referential Constraints
In a DB2 relational database, the “relational” components are those elements that provide relationship management and other powerful functionality to the IBM i DB2 database.
This section discusses the what, why and how of the various “constraints”, illustrating the enormous benefits obtained from the use of these components for a very small investment in time and effort.
0:01:36 Referential Constraints (Review)
0:02:11 Trigger Programs
0:04:21 Q and A
0:35:49 Constraint Naming Conventions
0:39:09 DB2 Modernization
0:39:47 Constraints + Triggers (Code Examples)
TEMBO (Developers of AO) has conducted various education workshops for global installations via Webex since 2016. The last series of workshops in 2017 was recorded for potential public consumption. These workshops were intended to provide the IBM i professional, specifically RPG developers, with an overview of the latest capabilities that have been provided in ILE, the RPG IV language, and elsewhere in the IBM i operating system to allow for vastly improved productivity, agility and the development of high-performance applications. Much emphasis is given to “data-centricity,” leveraging all the inherent unique capabilities of DB2 for i and modular reusable components.
Please see www.adsero-opt... and www.adsero-opt... for more details.