Articles & Content

Archives

The Power of SQL PL (G05)

Topic: 2008 NA

Subtopic: DB2 for LUW



DATE: 2008-05-20 (09:15 AM - 10:15 AM)
SPEAKERS: Herb Vogel (JB Hunt Transportation)

Unleash the Power of SQL PL from creating Stored Procedures to UDF's. From Tips and Tricks to Implementing and debugging. I will show users how this power will drastically change their job. From Application development to Migrating data, i will show users how SQL PL can make their Job easier. Will cover basic creation of Stored Procs and UDF's, as well as more advanced features, such as Temp tables and nesting and maintaining unit of work. How to bind procs using Temp tables that are defined in other procs, and will also cover debugging and tunning of proc's and UDF, as well as performance profileing.

EXP. LEVEL: Beginner,Intermediate

OBJECTIVES:

Stored Procs and UDF's : Types and usage

Creating basic Procs and UDF's

Advanced Procs: Temp Tables, Nesting , Unit of Work, Dynamic Result sets

Putting them to use in applications, examples, etc

Debugging and perfomance Profiling



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.