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.


  •  LINUX UNIX z/OS ON-SITE TRAINING  | IT SERVICES  | CONTACT US  | ISPF JCL REXX BOOKSTORE  | HOME

    Copyright © 2012 MVS TRAINING, INC. All rights reserved
    All trademarks & Copyrights are property of their respective manufacturers.