MVS TRAINING, Inc. z/OS, Assembler, COBOL, JCL, REXX, ISPF, CICS, DB2, ISPF/JCL

Back to Database

DB2 Universal Database (UDB) for z/OS and OS/390 Application Programming
5 Days

Our DB2 experts use lecture, learning checks and workshops to teach the following topics: DB2 relational concepts, normalized table design, use of SPUFI to access and update DB2 tables, use of embedded SQL statements, pre-compiler/bind options and the use of DB2 indexes for performance.

AUDIENCE
Designed for application programmers and analysts who want to code SQL and embedded SQL applications using DB2’s RDBMS.

GOALS

Understand the fundamentals of relational technology

Define the variety of DB2 physical and logical objects and their hierarchy

Understand how to join two tables together – function of SQL

Use DB2I panel options for queries, commands and utilities.

Access DB2 tables using SELECT SQL statement and discuss the variety of options available to this command

Understand table row modification using UPDATE, DELETE and INSERT (SQL)

SESSION CONTENT

3 Days (Using SPUFI)

DB2 Environment

Structure of DB2 – DB2 Objects

Relational Model and Operators, DB2 Objects, DB2 Interactive (DB2I)

Basic Database Design – Normalization

Elements, Functions, Language

SQL Data Definition Language (DDL)

SQL Data Manipulation Language (DML)

Scalar Functions (SQL)

JOIN, UNION, SUB-SELECT

2 Days (Embedded SQL for instance within a COBOL program)

Program Structure, DCLGEN, Program Preparation

BIND Process, Program Execution

Multiple-Row SELECT-CURSOR Usage

Optional: Illustrate DB2 components and their roles within CICS and IMS/TM.

Our DB2 experts can cover any and all topics on this subject—topics can be added or deleted per Client’s needs.

Pre-Requisites: Working knowledge of COBOL and TSO/ISPF.
WORKSTATIONS AND MAINFRAME ACCESS ARE NEEDED FOR THIS SESSION.

After taking this class, participant may take QMF, Advanced DB2, Stored Procedures, DB2 Design, and DB2 Administration.