POWERUp 2019 has ended
Experience the magic of education. 
Sunday, May 19 • 5:15pm - 6:15pm
18AL Creating a Master File Data Layer with SQL PL

Log in to save this to your schedule and see who's attending!

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 data layer (as opposed to a data tier in 3 tier architecture). The 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, web). We'll hit inquiry, delete, add and update. The update stored procedures include an optional one that does the equivalent of a CHAIN or pessimistic lock, if you are able to (and want to) control commit/rollback boundaries from within the high level language program.

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
  2. See differences in syntax and create steps for stored procedures using *LIBL and system naming (probably not applicable to all programming environments)

avatar for Rex Smith

Rex Smith

Sr. Developer (ERP & Web), Tegratecs Development Corp.
Rex is a Sr. Developer at Tegratecs and enjoys developing in both ERP and web environments. He is currently doing development work in RPG (at least 3 flavors), CLP, c#, DB2 for i and SQL Server (not all at once of course) and in his spare time, he likes to golf and play keyboards... Read More →

Sunday May 19, 2019 5:15pm - 6:15pm
Fantasy Tower North Ballroom A
  • Focused Education Roadmap SQL Programming
  • Level Intermediate
  • Operating System IBM i
  • Audience Developers looking to see and compare data update techniques between an SQL PL data layer and traditional record level access (RLA).

Twitter Feed