of Events





DB2 Links



Past Presentations

Register for

DB2 Forum 2017 Third Quarter Meeting

Wednesday, July 26, 2017
08:30 - 12:30 p.m.

Meeting Location:
The Original Pancake House
1505 William D Tate Ave.
Grapevine, TX

** 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.

This meeting is sponsored by IDUG and DFW DB2 Forum.

First Speaker
Tony Andrews - Themis Inc./IDUG Content Committee

Presentation Overview
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

Speaker Biography

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'.

Second Speaker
Tony Andrews - Themis Inc./IDUG Content Committee

Presentation Overview
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 also working. 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.

Speaker Biography

See above.

Third Speaker

Presentation Overview

Speaker Biography