DB2  

Course	Introduction to DB2 Application Programming
Level	Introductory
Overview	The participants will be introduced to the features, functions and services provided by DB2. The course describes DB2 data processing using SQL. The participants will learn how to code and debug DB2 programs written in COBOL. Lab sessions will help in reinforcing the concepts discussed during lectures.
Objective	On completing this course, participants will be able to - Use SQL Data Definition Language to create objects. Embed SQL statements in a COBOL program. Prepare these programs for execution. Set up a test data environment. Understand the functions performed by end users and programmers. Understand the responsibilities of database and system administrators.
Duration	Six (06) days: (09.30AM till 17.30AM)
Participant's Profile	Application programmers who will code and debug DB2 programs in COBOL.
Prerequisite	Basic knowledge of programming in COBOL. Working knowledge of TSO, ISPF and JCL.
Follow-on session	Mock or Live Project hands on is recommended after this course.
Course Contents	Day – 1 Introduction to DB2 Database overview Database models DB2 overview Roles and responsibilities Introduction to SQL SQL – Data Definition Language DB2 objects – STOGROUPS, Databases, Tablespaces, Tables Catalog tables Indices Views Designing tables for DB2 Naming conventions Column data types Keys Inserting, changing and deleting data Processing rules Lab Session – 1 Day – 2 Program preparation Program preparation steps Creating packages Setting up the test environment Running, testing and debugging programs SQL – Data Manipulation Language SELECT Accessing data from more than one table Sub query Using functions Grouping Lab Session – 2 Day – 3 SQL in programs Host variables Indicator variables Cursors Fetch Exception conditions Dynamic SQL Lab Session – 3. Day – 4 More on SQL Correlated subqueries Set operators Predicates Constraints Triggers Joins Lab session – 4 . Day – 5 Application design Coding transactions COMMIT and ROLLBACK Restartable programs Error handling Locking Reasons for locking Locking modes, sizes and durations Locking strategies Lab Session – 5. Day – 6 Security Privileges Administrative authority GRANT and REVOKE Using views for security DB2 utilities LOAD, UNLOAD RUNSTAT Maintenance and recovery utilities Lab Session – 6.