Creating a Master File Data Layer with SQL PL

Innovative Solutions for Your Evolving Needs

Creating a Master File Data Layer with SQL PL
(a technical report bundle available for purchase)

See and understand standard IBM SQL PL and stored procedure syntax that performs all of the DB access used within this data layer pattern example
See differences in syntax and creation steps for stored procedures using Db2 for i *LIBL (schema priority at run-time)

See below for option to purchase this technical presentation
(currently on v2)

**purchase includes downloadable updates and new versions for 3 years**

(a technical presentation created for POWERUp 2019 ANAHEIM conference and expo)

Chart on What We’ll Cover in the Presentation
(better than the TOC)

Topic	Covering	Notes	Download
List of Stored Procedures	Yes	8 in this example
PL Source Code	Yes		Yes
Parameters	Yes
IDE	Compiling	Just a little bit about Navigator (CA 7.1 and ACS), RDi - Video
Consuming - Mode Usage	Yes	Easily implied
Consuming - Overlay Prevention	Overview	Sequence and Conditions of recommended method for preventing overlays - more advanced - involves commit boundaries
Plumbing and Connecting	No
Software Prerequisites	Some

This session won't get into too much detail when it comes to IDE(s) or plumbing (such as connecting to the database), primarily so our time can be devoted to the working SQL PL pattern example included and to see how it solve challenges that are applicable to most anyone creating stored procedures for use with user-initiated enterprise level master file maintenance.

Important - The keys that enable immediate download (directly after purchase) are emailed to the PayPal Account holder used with the purchase (and to a second email address if you are logged in to tegratecs.com under a different email address).

Purchase technical report bundle
Creating a Master File Data Layer with SQL PL
HERE
(LogIn to PayPal required)
(you will have the option to continue or to cancel on PayPal)
$95 US
(get immediate access plus all subsequent updates and versions for 3 years)

Creating a Master File Data
Layer with SQL PL

Abstract:

This presentation 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 RPG CHAIN or pessimistic lock, if you are able to (and want to) control commit/rollback boundaries from within the high level language program. The examples also cover the steps required to do optimistic row locking (and prevent overlays) while allowing concurrent maintenance with other separate and distinct processes.

Learning Objectives:

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

Site Map Switch to
Mobile View



Innovative Solutions for Your Evolving Needs

Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )

Creating a Master File Data Layer with SQL PL (a technical report bundle available for purchase)

Creating a Master File Data Layer with SQL PL
(a technical report bundle available for purchase)