SQL PL Best Practices - Cross Platform

Session Number: 6393
Track: Educational Seminars
Session Type: Educational Seminar
Primary Presenter: Tony Andrews [Themis Inc.]
Time: Jun 02, 2019 (09:00 AM - 05:00 PM)
Room: Governors ballroom 2

Speaker Bio: 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 RDBMS 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’.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers
Technical areas this presentation will apply to: Triggers, Stored Procedures, UDFs
Objective 1: Understand the benefits of Stored Procedures
Objective 2: Learn how to use the IBM Data Studio to code, test, deploy, and debug SQL PL Stored Procedures
Objective 3: Understand the new XML and Array parameters
Objective 4: Understand the many ways of error handling
Objective 5: Leave with many of SQL PL best practices

Abstract:  One of the most anticipated new features of Db2 was the SQL PL stored procedures (especially on z/OS). A key advantage is the ability to work entirely within the IBM Data Studio environment to accomplish Db2 development and deployment. Students will have the ability to log in and code a few stored procedures during this educational seminar. And also leave with some Best Practices of the language. Topics like XML parameters, array parameters, autonomous processing, piece-wise delete, and others will be talked about. This is for everyone on either Db2 platform.