About ABIS
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data and AnalyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
Db2 SQL PL, triggers, stored procedures & user-defined functions

Since quite some time now, the possibility exists to integrate extra functionality in your database by means of stored procedures, triggers and user defined functions. Meanwhile, these features have proven to be indispensable, especially for improving modularity, reusability, and security. Time for you to start using these functional objects!

In this course the advantages and disadvantages of stored procedures, triggers and user defined functions are explained. Participants also learn to apply the right tool.

Participants will also get a technical insight in the set-up and the use of stored procedures, triggers and user-defined functions. Both external stored procedures and stored procedures set-up with SQL PL (the 'SQL procedural language') are discussed. The SQL PL language is treated in sufficient depth such that participants will be able to write even fairly complex procedures. For those who want to go deeper into SQL PL, we refer to the course SQL PL database programming


No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please contact ABIS.

Intended for

Application developers and technical analysts who have to develop stored procedures, triggers or user defined functions.

DBAs and data base designers who want to know the new possibilities in Db2 and learn how triggers and stored procedures can help implement the logical design, the data integrity, and the access control of a relational database.


Participants should be familiar with SQL (see SQL and relational databases fundamentals) and with Db2 for z/OS (see Db2 for z/OS fundamentals course) or Db2 for Linux, Unix and Windows (see Db2 for LUW fundamentals course). Knowledge of an application programming language (COBOL, PL/I, C, Java, SQL PL, ...) is not required.

Main topics

Training method

Classroom instruction with examples and exercises.


1 day.

Course leader

Peter Vanroose.

Global score

3.7/5 (based on 52 evaluations)


Goed. Docent moet op snelheid van praten letten. (, )
Goed, voor mijn niveau iets te hoog (te weinig sql ervaring) (, )
Voldoende voor mijn behoefte aan kennis (, )
Prima cursus. (, )
Helaas problemen met beschikbaarheid van onze db2 Unix/linux omgeving. (, )
Gaf vrij precies wat ik wilde. Niet te veel tijd aan praktijk besteed. (, )
jammer dat onze oefenomgeving niet correct werkte. Op zich wel een idee gekregen van de mogelijkheden (, )
Goede cursus, maar te weinig tijd voor oefeningen. Ook zou het handiger zijn om in een andere omgeving dan SPUFI te werken met oefeningen. (Omslachtig en kost teveel onnodige tijd.) Data Studio bijv. (dat wordt bij CZ ook gebruikt.) (, )
cursus inhoud goed voor een eerste verkenning met Sp's, triggers en udf. De stof en oefeningen gaan veel verder, maar daar kom je in t algemeen niet aan toe (, )
Eerste dag was voor mij iets te langdradig/simpel. tweede en derde dag was nivo goed (, )

Also interesting

Enrollees for this training also took the following courses: