COMMON POWERUp 2021

This session will examine working examples of IBM SQL PL, for maintaining and inquiring upon a "master" file. The SQL PL statements will be segregated into a set of stored procedures, probably best described as a simple data layer. IBM SQL PL is standardized across all of the versions of Db2. The (complete SQL PL) examples seek to show how one might separate data access and update logic from the high-level language program, and facilitate broader ease of use and consistency across the enterprise (interactive, batch and/or remote web server)). We'll hit inquiry, delete, add and update. The update stored procedures include working examples of those that achieve the optimistic record locking technique even from a remote web server, so that accidental overlays are prevented in high volume, multi-user environments without allocating the record. The optimistic technique reviewed does require use of commit/rollback boundaries from within your high-level language program. We won’t have time to get into consuming the stored procedures however, so the specifics of high-level languages calling the stored procedures won’t be covered.

Learning Objectives:
1. See and understand standard Db2 for i SQL PL and stored procedure syntax that performs all of the DB access used within this data layer pattern example_x000D_ 2. See differences in syntax and create steps for stored procedures using *LIBL and system naming (probably not applicable to all programming environments)