Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.