|
|
|
|
400+ Course Offerings:
| DB2 for z/OS |
| DB2 for Linux, UNIX, Windows |
| CICS/TS |
| MQSeries |
| Web Services, SOA and XML |
| WebSphere |
| WebLogic |
| IMS |
| Mainframe - Assembler, COBOL, MVS/JCL, REXX, SAS |
| Java/J2EE & Frameworks |
| Linux |
| UNIX, C, C++ |
| Oracle |
| Sybase |
| PowerBuilder / InfoMaker |
| Data Warehouse, Data Modeling and Database Design |
| Microsoft - .NET, SharePoint, SQL Server |
| Project Management |
|
|
DB1029 Exploiting Native SQL Stored Procedures on DB2 9 for z/OS
|
|
|
|
View Schedule and Enroll
|
|
Full Course Description
|
| |
|
Duration |
2 Days |
|
Delivery Method |
Instructor Led, Hands-on workshops |
|
Public Price |
$950.00 | |
DESCRIPTION (Return to Top)
This course provides DB2 developers with the technical knowledge necessary to develop efficient SQL PL Stored Procedures with the IBM Data Studio. These tools may be used with DB2 on any platform. The course also covers the DB2 Unified Debugger.
AUDIENCE (Return to Top)
Analysts and programmers involved in the development of DB2 for z/OS SQL Stored Procedures.
OBJECTIVES (Return to Top)
Upon successful completion of this course, the student will be able to: - Understand the benefits of Native SQL PL Procedures
- Code DB2 Stored Procedures using SQL Procedure Language
- Use the IBM Data Studio to develop SQL Procedures
- Use the Unified Debugger to test and troubleshoot stored procedures
TOPICS (Return to Top)
- Introduction to Stored Procedures
- The SQL Procedure Language
- Working with SQL Procedures
- IBM Data Studio
- Global Temporary Tables
- Unified Debugger
PREREQUISITES (Return to Top)
Understanding of relational database concepts and SQL syntax (DB2 SQL For Everyone or equivalent).
|
|
|
|
|