DB2 Application Programming

PT10690
Summary
This course provides the student with information and practice for all ANSI SQL for the manipulation of data in a DB2 database. In addition embedded SQL in COBOL is presented along with performance considerations, recovery and access to the DB2 catalog.
Prerequisites
Students should have familiarity with TSO and COBOL.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for programmers who will access DB2 from SPUFI, QMF and COBOL application programs.
Topics
  • Tables
  • Definition
  • Names
  • Data Types
  • Nulls
  • Create Table Statement
  • Nulls In Table Display
  • Check Constraint
  • Referential Integrity
  • Select Query - The Basics
  • Select Query Group By
  • Select Query - Subqueries
  • Select Query Join
  • Action Queries
  • Embedding SQL in COBOL
  • Performance Considerations
  • Miscellaneous Topics
  • Appendix

Related Scheduled Courses