home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and 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 and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 SQL PL, triggers, stored procedures & UDF

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.

Background

Participants should be familiar with SQL (see SQL 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, ...) is not required.

Training method

Classroom instruction with examples and exercises.

Course leader

Peter Vanroose.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
31/08/2010ELeuven450 EUR
09/12/2010NWoerden450 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

Since quite some time now, the possibility exists to integrate extra functionality in your data base 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.

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.

Main topics

  • SQL PL:
  • The procedural language of DB2: a thorough introduction
  • How to use variables, create cursors, throw exceptions, verify conditions, ...
  • Triggers:
  • What are triggers?
  • How and when do we use triggers?
  • Writing triggers
  • Examples and exercises
  • Stored procedures:
  • What are stored procedures: advantages and disadvantages?
  • When do we use stored procedures?
  • External stored procedures (written in COBOL, PL/I, C, Java, ...)
  • Stored procedures written in SQL PL
  • Examples and exercises
  • User defined functions:
  • User defined functions: introduction
  • How do we code user defined functions?
  • When and how to use UDFs?
  • Examples and exercises