home 
 
 
 
enfr
 
Home
Over ABIS
Diensten
Cursussen
Resources
Contact
MyABIS
Alle CursussenbalkjeAlgemeen » Introductie HW & SW » TrajectenOperating Systems » MVS - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transactiesystemen en middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence en data warehouseApplicatieontwikkeling » Methoden en technieken » TOGAF » PRINCE2 » Programmeertalen » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSysteembeheer » ITILbalkjePraktischInschrijven 
Deze pagina is niet beschikbaar in het Nederlands.
DB2's SQL PL revisited:triggers, stored procedures, and user-defined functions

Intended for

Any DB2 user (developer, DBA, analyst, designer, ...) who either considers implementing some functionality through stored procedures, triggers or user defined functions, or has been confronted with having to use them.

Background

Participants should be familiar with DB2 for z/OS (see DB2 for z/OS fundamentals course).

Course leader

Peter Vanroose.

Duration

1 evening (2 hours).

Schedule

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.

Objectives

This evening session is one in a series of six where we will bring you up-to-date on some selected topics related to DB2 for z/OS. The individual sessions can be followed independently, or you may sign up for the full series.

In this session the typical use, the advantages and disadvantages of stored procedures, triggers and user defined functions (UDFs) are explained. Both "old" possibilities and "new" (i.e., versions 8 and/or 9) features will be highlighted.

Main topics

  • Stored procedures:
  • What are stored procedures: advantages and disadvantages?
  • When do we use stored procedures?
  • External (COBOL or PL/I) stored procedures versus stored procedures written in SQL procedural language
  • Examples
  • Triggers:
  • What are triggers?
  • How and when do we use triggers?
  • Writing triggers
  • Examples
  • User defined functions:
  • How does one write user defined functions?
  • Examples