Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DB2 > DB2 for z/OS Application Programming Training

DB2 for z/OS Application Programming Training

Course#: WA1336

This workshop is designed to provide knowledge of using SQL in DB2 for z/OS. This knowledge can be applied to implementing SQL into programs (COBOL programs will be used). Hands-on practice with DB2 will be included, in order to reinforce the concepts and techniques studied in the course. Performance improving techniques will be discussed and the output from the DB2 optimizer will be analysed, using the EXPLAIN facility.

Objectives:
  After completing this course the student should be able to:
  • Understand the concepts of a relational database system.
  • Use SPUFI (on TSO/ISPF) to write SQL queries.
  • Embed SQL commands into a batch COBOL program to read and update data from tables.
  • Code a SQL in a program to access multiple rows of data.
  • Prepare and execute programs.
  • know the locking strategies available with DB2.
  • understand the basic features and options available when using DB2 packages and plans.
  • Be familiar with several DB2 objects.
  • Identify SQL performance improving techniques and use EXPLAIN to analyse SQL statements.
  • Design DB2 indexes for performance.
  • Identify design issues in batch programs that require SQL COMMIT commands. Identify techniques for recovery and restartability in programs.
Target Audience:
  Programmers, Analysts, Project leaders, managers and end users, who need to access DB2 data on OS/390 or z/OS.
Prerequisite:
  COBOL programming experience.
Format:
  Lecture with hands-on workshops.
Duration:
  Five days.

Outline of WA1336 DB2 for z/OS Application Programming Training

Day 1

  • Basic Theory
  • SQL Introduction
  • SPUFI
  • SQL Lab 1
  • SQL Basics
  • SQL Lab 2
  • SQL Basics (continued)
  • SQL Lab 3

Day 2

  • SQL Table Joins
  • SQL Lab 4
  • SQL Subselect
  • SQL Lab 5
  • DML and Objects
  • SQL Lab 6

Day 3

  • Preview (optional)
  • SQL in PROGRAMS
  • LAB preparation and workshop #1
  • Error Handling
  • workshop #2

Day 4

  • Program Preparation
  • DB2 Security
  • workshop #3
  • DB2 Objects
  • DB2 Locking
  • SQL - OUTER JOINS/CASE Expressions
  • workshop #4
  • SQL for PERFORMANCE
  • The DB2 CATALOG
  • workshop #5

Day 5

  • COMMITS and BATCH PROGRAMS
  • ONLINE PROGRAMMING
  • Using EXPLAIN
  • workshop #6
  • REVIEW of the latest enhancements in DB2
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.