Db2 Stored Procedures Workshop provides an introduction to the Db2 stored procedure environment. Upon completion of this course, the students will have the skills necessary to create stored procedures using SQL PL, Java, and other programming languages. Students also will have the skills to create the necessary code in client/calling applications to invoke the Db2 stored procedures. This course is designed to be taught in an UNIX/NT training environment, however with the proper software it can also be taught on a OS/390 host system. Regardless, the concepts learned can be applied to any platform.
Students should have a basic understanding of Relational Database Management Systems and Structured Query Language (SQL). Also, a working knowledge of a programming language, such as ‘C’ language or Java is recommended, but not mandatory.
2-3 Days/Lecture & Lab
This course is designed for data base administrators and application developers working in a Db2 for OS/390 environment, in any Db2 version through version 7.