DB2 Application Programming

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.
Students should have familiarity with TSO and COBOL.
5 Days/Lecture & Lab
This course is designed for programmers who will access DB2 from SPUFI, QMF and COBOL application programs.
  • 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