DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2, DB2 SQL procedures

From the developerWorks archives

Marina Greenstein and Shakeb Shere

Date archived: January 12, 2017 | First published: October 02, 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).

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=342919
ArticleTitle=DB2 9.5 SQL Procedure Developer exam 735 prep, Part 2: DB2 SQL procedures
publish-date=10022008