Attending this event?
Join your friends and colleagues in the COMMON community at POWERUp 2020. In the company of peers and over 100 industry experts, you’ll enjoy the best in Power Systems and IBM i education over the course of 4 days. View the list of nearly 400 sessions, which cover over 20 areas of IT. POWERUp also boasts the largest exposition of its kind. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?
Back To Schedule
Wednesday, September 2 • 4:00pm - 5:00pm
Creating a Master File Data Layer with SQL PL

Log in to save this to your schedule, view media, leave feedback 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 (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 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 your high-level language program. This technique will work with most, if not all, high-level languages that can call Db2 for i stored procedures. However, we won’t have time to get into high-level language specifics.
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 business applications in traditional IBM i environments and in web environments. Rex enjoys interacting with customers and designing business application software that solves problems and meets user needs. He is currently... Read More →

Wednesday September 2, 2020 4:00pm - 5:00pm
Inman 211 North Tampa Street Tampa, FL 33602
  • LEVEL Intermediate
  • AUDIENCE Developers looking to see and compare data update techniques between an SQL PL data layer and traditional record level access (RLA).

Attendees (3)