DB2 Forum 2017 Third Quarter Meeting
Wednesday, July 26, 2017
08:30 - 12:30 p.m.
The Original Pancake House
1505 William D Tate Ave.
** Directions to The Original Pancake House **
The Original Pancake House is in Grapevine on William D Tate Ave just south of 114 and east of 121. It
is between Buffalo Wild Wings and Freebirds World Burrito across the street from Classic Chevrolet.
Meeting Cost: $10 for non-members, free to members. Membership is $25 per
year per person --or-- $100 for 5 people in a company --or-- $350 for
unlimited people in a company. You can register at the meeting.
- Themis Inc./IDUG Content Committee
SQL-PL Native Stored Procedure Language
Learn to code simple and more complex programs in the SQL Procedure Language (SQL PL). This is the
language used by most stored procedures being written today on DB2 for LUW and z/OS.
We'll see the basics of the syntax and discover just how easy it is to code stored procedures using this
language. Some of the areas to be covered are:
- Creating and Deploying using IBM Data Studio
- Declaring Variables
- Loop/Leave/Repeat logic
- If/Case logic
- Error Handling
- Array and XML variables
Tony Andrews has more than 25 years' experience in the development of relational database applications.
Most of this time, he has provided development and consulting services to Fortune 500 companies and
government agencies. Tony has written literally thousands of queries and programs during his development
years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time
between performance and tuning consulting engagements along with training. His main focus is to teach
today's developers the ways of RDMS application design, development and SQL programming -- always
with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker
at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers
titled 'DB2 SQL Tuning Tips for z/OS Developers'.
Tony Andrews - Themis Inc./IDUG Content Committee
Fun with SQL
A SQL Dojo is a meeting where a bunch of developers, DBA and SYSPROGS get together to work on a
number of SQL challenges. They are there to have fun and to engage in a group effort in order to improve
their skills in a non-competitive, collaborative, fun environment. The goal is to have practical hands-on
experience within a group of peers, learning a specific technical skill within one hour at IDUG
The exercise is considered successful when it is completed within allocated time AND audience can
repeat the exercise at home by themselves. At the end of the dojo the participants receive, a working
solution by dojo leaders, which might not correspond to the solution the participants came up with, but is
No worries; we are going to work together as a big group as Tony leads us through 'Fun with SQL' to
make sure we get the most out of Stored Procedures and SQL-PL.