DB2 for OS/390 APPLICATION DEVELOPMENT
Duration
Five Days
Pre-requisite
Programming experience
Who Should Attend
This course is intended for Application programmers, application analysts, database designers or anyone who needs to code SQL in or outside of an application program.
Course Description
DB2 for OS/390 Application Development offers the student a unique opportunity to learn how to use both interactive and embedded SQL. Typical business processing requirements are analyzed and coded into SQL statements. The SQL statements are tested using SPUFI, a DB2 interactive facility. In the programming phase of this course, the SQL statements are embedded in batch COBOL or PL/I program that executes under TSO.
Course Topics
- DB2 Concepts and Facilities
- The Order Item Database
- Basic SQL Select Operations
- Basic SQL Insert, Update, and Delete Operations
- Column Functions
- Subquery, Join, and Union Operations
- Views and Nested Table expressions
- DB2 Programming Overview
- Embedded SQL
- Cursor Processing
- DB2 Commit Processing and Program Isolation
- The EXPLAIN Function
- Stored Procedures
- Testing and Implementing DB2 Programs
- Embedded SQL Syntax
