DB2 Application Programming

 

     

Objectives:

 

On this course you will learn to develop application programs, making efficient use of DB2 resources

Subjects covered:

  • DB2 overview
  • DB2 Data types and NULLS
  • SQL DML and DDL
  • Advanced SQL
  • SPUFI and DB2 interactive
  • Preparing the DB2 Application Program
  • Program Structure
  • Security
  • Dynamic SQL
  • Performance Considerations
  • EXPLAIN Facility
  • Referential Integrity
  • Batch
  • IBM Query Management Facility (QMF)
  • DB2 Utilities

Participants:

Programmers, Analysts, DBA’s and those responsible for the design, developement and coding of DB2 applications

Prerequisites:

TSO/SPF knowledge, a programming language (the demonstrations shall be given using COBOL) and an understanding of basic programming concepts.

Remarks:

None

Teaching method:

Classical, with examples and practical exercises.

Course duration:

5 days.

Cost:

1700,- EUR excl. tax

Register for course: