Loading…
Welcome to the Online Session Guide for the COMMON 2016 Annual Meeting and Exposition. Using this tool, you can access information regarding the sessions offered, build a custom schedule, print off handouts, and participate in session evaluations. We look forward to seeing you in New Orleans!
View analytic
Wednesday, May 18 • 11:00am - 12:15pm
43AJ DB2 for i SQL Routines (Triggers, Functions and Procedures) Overview

Sign up or log in to save this to your schedule and see who's attending!

SQL is much more than a query language. This session introduces you to the three basic types of SQL programs: Triggers, Functions, and Procedures. Learn how to let the DB do more work on your behalf.

Learning Objectives:




  • Add logic to your DB objects Using SQL Triggers



  • Centralize logic using SQL functions



  • Access most any kind of data as if its relational table via User Defined Table functions



  • Learn the basics of SQL Stored procedures





This is session 610065

Speakers
avatar for Jim Denton

Jim Denton

Senior DB2 for i Consultant, IBM
Jim Denton is a senior DB2 for i consultant in IBM Systems Lab Services whose responsibilities include both teaching courses and "hands on" consulting. Jim specializes in SQL performance, data centric programming, and database modernization. Jim started his IBM career in 1981 and... Read More →


Wednesday May 18, 2016 11:00am - 12:15pm
Grand Salon 7&10 | First Floor
  • Session Content Level Beginner
  • Operating System IBMi
  • Audience: Programmers

Twitter Feed