Training

Popular Courses

IBM

MICROSOFT

Enterprise Architecture (EA)

SOA

Java/Java EE

Cloud Computing

Agile

Mobile computing

SCHEDULED CLASSES

COURSE
MAP

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

VIRTUAL CLASSROOMS

ROOM RENTALS

Contact Training Sales

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

439 University Av
Suite 820
Toronto, ON
M5G 1Y8

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 >

WA1337 DB2 for OS390 Application Programming Training and Courseware

This workshop is designed to provide instruction on COBOL programming using DB2 for OS/390. 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:
  • embed SQL commands into a batch COBOL program to read data from tables and also update DB2 tables.
  • code a program to use an SQL "cursor processing" technique.
  • Prepare a program for execution.
  • execute and test a batch program
  • use EXPLAIN to analyse SQL commands.
  • 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 and the operating environment.
Target Audience:
  Programmers and programmer/analysts.
Prerequisite:
 
  • COBOL programming experience.
  • Previous experience or classroom instruction in SQL.
Format:
  Lecture with hands-on workshops.
Duration:
  Two days.

Course Outline

Day 1

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

Day 2

  • Program Preparation
  • DB2 Security
  • LAB 1, workshop #2
  • DB2 Objects
  • DB2 Locking
  • Query Analysis using EXPLAIN
  • LAB 2 - optional
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.
More Details
Outline Course Outline
Buy This Course

Buy on-site and customized class

*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

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

Thank you!.