 | Level: Introductory Marina Greenstein (greenstm@us.ibm.com), Executive IT Specialist, IBM
25 Sep 2008 In this tutorial, learn about IBM® DB2® 9.5 SQL
Procedural Language, including a variable, condition, and handler declaration,
flow of control and iterative statements, as well as an error-handling mechanism.
This is the first in a series of six tutorials you can use to help prepare for the DB2 9.5
SQL Procedure Developer exam 735. The material in this tutorial primarily covers the objectives
in Section 1 of the test, which is entitled "SQL Procedure Language."
Objectives - Learn basic elements of SQL PL
- Understand how to declare variables, conditions, and handlers
- Learn about the flow of control statements
- Learn cursor processing and how result sets can be returned
- Understand error-handling mechanism
Prerequisites
To take the DB2 9.5 SQL Procedure Developer exam, you must have already
passed the DB2 9 Family Fundamentals exam (Exam 730). You can use the
"DB2 Family Fundamentals tutorial series" to prepare for that exam. It
is a very popular series that has helped many people understand the fundamentals of the DB2 family of products. For this tutorial to be useful, you should have background knowledge of
how a relational database works as well as basic knowledge of
databases and database programming constructs.
System requirements
You do not need a copy of DB2 9.5 to complete this tutorial. However,
you will get more out of the tutorial if you download the free trial
version of DB2 Express-C to work along with this tutorial.
Formats html, pdf
Tutorial series overview
This series of six DB2 SQL Procedure Developer tutorials covers all the
basic constructs and methods of the SQL Procedural Language and shows
how it can be used in stored procedures. user-defined functions, and
triggers, including error handling and deployment. It also covers some
DB2 9.5 advanced features like optimistic locking, hierarchical
queries and declared global temporary tables. This series provides
specifics on how the stored procedure can be invoked and how you can
share data between procedures and functions. It introduces the DB2
development tool, including IBM Data Studio. These tutorials provide a
solid base for each section of the exam. However, you should not rely
on these tutorials as your only preparation for the exam. More exam
resources can be found in the Resources section of this tutorial.
| | | |
