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 zOS Advanced Programming Training

DB2 for zOS Advanced Programming Training

Course#: WA1338

This course is designed to provide instruction with advanced DB2 programming techniques for 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.

Outline of WA1338 DB2 for zOS Advanced Programming Training

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.
*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.