Baltimore / Washington DB2 Users Group
Archived
BWDB2UG's DB2 Educational Session


David Simpson

When? Wednesday, March 12th, 2014, 9:00AM-3:30PM (registration at 8:30)

Where? Sheraton Columbia Hotel, 10207 Wincopin Circle, Columbia, MD (410) 730-3900

Meeting Fees:
Pre-registered: $250 (lunch and break refreshments included)
At-the-door: $350 (lunch and break refreshments included)

Meeting Schedule:

  8:30 - 9:00 Registration
 
  9:00 - 10:15 DB2 for z/OS Native SQL Stored Procedures Best Practices
  David Simpson, Themis Inc.
 
 

As mainframe IT organizations begin to implement “Native” SQL Stored Procedures they are running into some logistical challenges integrating them into their z/OS environment. This presentation provides an overview of the environment as well as some solutions to common challenges.

Topics Include:

  • Overview of Stored Procedure Options
  • Native Stored Procedure Lifecycle
  • Introduction to the SQL PL Language
  • IBM Data Studio as a Development and Testing Tool
  • Change Control
  • Bind / Deploy
 
  10:15 - 10:30 Coffee Break
 
  10:30 - 11:45 DB2 for z/OS Native SQL Stored Procedures Best Practices (cont.)
  David Simpson, Themis Inc.
 
  11:45 - 12:45 Lunch
 
  12:45 - 2:00 DB2 for z/OS - SQL for the 21st Century: Overlooked Enhancements
  David Simpson, Themis Inc.
 
 

Are you still coding like it’s the 90s? This session will cover some overlooked SQL enhancements in the latest releases of DB2 with a special focus on features that have been most useful in real DB2 environments.

Topics Include:

  • Online Analytical Processing (OLAP) Built-in Functions
    • Overview of Grouping
    • Ranking and Row Numbering
    • Moving Aggregates
    • Aggregation Partitioning
    • Grouping Sets, Rollup & Cube
  • Common Table Expressions
    • Multiple Levels of Aggregation
    • Recursive SQL
  • MERGE Statement
  • SELECT FROM Insert/Update/Delete/Merge DB2 11 Preview of SQL Enhancements
 
  2:00 - 2:15 Break
 
  2:15 - 3:30 DB2 for z/OS - SQL for the 21st Century: Overlooked Enhancements (cont.)
  David Simpson, Themis Inc.
 

To pre-register, you can 1) use PayPal or 2) mail a check.

1) To pay via PayPal, simply click the link below and follow the directions; then send us an email to let us know the names of everyone in your group who will be attending.

2) To pay by check, mail the check with attendee and company name to:

NOTE: New Address

The Baltimore/Washington DB2 Users' Group
P.O. Box 1027
Owings Mills, Maryland 21117

All pre-registrations must be received by Friday, March 7th, 2014.

Please note: Refunds will not be granted for this seminar for cancellations after this date. However substitution of another person can be made up until the meeting.

Directions to the Sheraton Columbia Hotel
Generate directions via Google Maps
From Baltimore and North
Take I-95 South and exit Rt. 175 West (exit 41B). Travel 6 miles on 175 West. After crossing Rt. 29, go through 5 lights. After the 5th light, make first left onto Wincopin Circle. The Sheraton Columbia Hotel and Conference Center is located at the end of the Wincopin Circle, on the lake.
From Washington and South
Take I-495 East to I-95 to Rt. 32 West. Travel 3 miles North to Rt. 29 North. Travel 2 miles on Rt. 29 North to Broken Land Parkway (exit 18B). Follow signs for Columbia Town Center to Little Patuxent Parkway. Turn right and go through 3 lights. Wincopin Circle is on the right. Go to second entrance of Wincopin Circle and turn right. The Sheraton Columbia Hotel and Conference Center is located at the end of Wincopin Circle, on the lake.
Speaker Backgrounds
David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.
Have a topic?
The Baltimore/Washington DB2 Users' Group welcomes suggestions for topics of interest for future meetings. Drop us a line if you have a particular topic you feel would be of interest. If you would like to share, then volunteer as a speaker and gain the satisfaction of helping other DB2 professionals benefit from your experiences.