Level: Intermediate Marina Greenstein (greenstm@us.ibm.com), Executive IT Specialist, IBM
Shakeb Shere (shakebs@ca.ibm.com), IBM DB2 Common Client Technologies advanced support analyst, IBM
02 Oct 2008 This tutorial introduces the SQL procedure as it relates to DB2® V9.5. Learn
about DB2 9.5 SQL procedures, including an introduction to stored procedures, the advantages of using stored procedures, and the differences between SQL procedures and external procedures. Learn about different SQL procedure statements and see how to invoke and share nested stored procedures. Test and deploy stored procedures and discover how to secure SQL procedures. This tutorial is the second in a series of six tutorials designed to help you prepare for the DB2 9.5 SQL Procedure Developer Certification Exam (735).
Objectives - Get an introduction to stored procedures
- Discover the advantages of using stored procedures
-
Uncover the differences between SQL procedures and external procedures
-
Learn about the SQL procedure statement
- Discover how to invoke and share nested stored procedures
- See how to test and deploy stored procedures
-
Learn how to secure SQL procedures
Prerequisites
This tutorial is written for Linux®, UNIX®, or Windows® database developers or administrators, whose skills and
experience are at a beginning to intermediate level. You should have a general familiarity with using a UNIX or Windows command-line shell and a working knowledge of DB2 and SQL commands.
System requirements
The examples in this tutorial are specific to DB2 9.5 running on a Windows operating system. The concepts and information provided are relevant to DB2 running on any distributed platform. 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 IBM DB2 9.5 to work along with this tutorial.
Formats html, pdf
Tutorial series overview
Thinking about seeking certification on DB2 SQL Procedure Developer (Exam
735)? If so, you've landed in the right spot. This series of six DB2
certification preparation tutorials covers all the basics -- the topics
you'll need to understand before you read the first exam question. Even if
you are not planning to seek certification right away, this set of tutorials is a great place to start learning all about database development for DB2 V9.5.
Tutorial overview
In this tutorial, you'll learn about DB2 9.5 SQL procedures, including an
introduction to stored procedures, the advantages of using stored procedures, and the
differences between SQL procedures and external procedures. Learn about different
SQL procedure statements and see how to invoke and share nested stored procedures.
Test and deploy stored procedures and discover how to secure SQL procedures.
This is the second 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 2 of the test, which is entitled "SQL
Procedures". See Resources.
| 
