In applications multiple steps have to be consolidated and executed as a unit (Transaction). That means either all steps or none of the steps must be performed. Example: an order has to be completely delivered or not at all.No problem if everything is okay, but what if there is suddenly not enough inventory for one position?Everything has to be reset … and this can become tricky, because multiple programs were executed, multiple rows in different tables were updated and may be even constraints or triggers were activated.The solution is Commitment Control. Even though Commitment Control is not new, it is only rarely used in (traditional) IBM i applications. … but it is essential for keeping data consistent, especially when using techniques such as referential integrities and triggers.… and it is even for traditional applications important.… so, it is time to start!
Date & Time
Wednesday November 6th, 2024 11:00am EST
End Date & Time
Wednesday November 6th, 2024 12:00pm EST
Venue
Pier 4
Speakers
Birgitta Hauser
Session Format
Standard 60 Minute Session
Learning Objectives
- Commitment Control
- Transaction Control
- Start/End Commitment Control
- Commitment Level
- Commit and Rollback
- Commitment Control in Programs
- (Embedded) SQL and Commitment Control
- Work with Commitment Definitions
Audience
Programmers who want to start with commitment control or want to keep their data consistent
Session Level
Intermediate
Evaluation Link
https://docs.google.com/forms/d/e/1FAIpQLScZUqaHcpJfO1HYO4XDagewGyp12uhBOCbFHeU3zFMSGu8Egg/viewform?usp=pp_url&entry.86355973=Commitment Control - Transaction Control&entry.1165051396=Birgitta Hauser
Conference NAViGATE Toronto
Session Comments