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 >

WA1338 DB2 for zOS Advanced Programming Training and Courseware

This course is designed to provide instruction with advanced DB2 programming techniques for OS/390 or z/OS. Performance improving techniques will be stressed. Techniques involving BATCH and ONLINE programming techniques will be reviewed. The EXPLAIN facility of DB2 will be used to analyse DB2 programs and SQL. The DB2 Catalog will be used to analyse physical objects.
Objectives:
  After completing this course the student should be able to:
  • Write advanced SQL queries and create views to access data.
  • Embed dynamic SQL in a COBOL program.
  • Identify SQL performance improving techniques and use EXPLAIN to analyse SQL statements.
  • Design DB2 indexes for performance.
  • Identify issues in batch programs that require SQL COMMIT commands. Identify techniques for recovery and restartability in batch programs.
  • Identify issues for ONLINE programs that affect performance and page browsing.
  • Use SQL to analyse the DB2 catalog.
  • Review techniques for using packages and plans.
Target Audience:
  Programmers.
Prerequisite:
 
  • COBOL programming experience. Previous classroom instruction in DB2 and SQL.
  • Previous experience of writing DB2 programs would be beneficial.
Duration:
  Three days.

Course Outline

Day 1

  • ADVANCED SQL
  • Lab #1
  • SQL - OUTER JOINS/CASE Expressions
  • Lab #2
  • SQL for PERFORMANCE
  • The DB2 Catalog
  • Lab #3

Day 2

  • Using EXPLAIN
  • Lab #4
  • DYNAMIC SQL PROGRAMMING
  • LAB #5

Day 3

  • COMMITS and BATCH PROGRAMS
  • CICS PROGRAMMING
  • DB2 PACKAGES
  • Programming enhancements by DB2 Version
  • Additional SQL enhancements
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!.