This course focuses on the design, implementation, testing and integration of an IBM DB2 enterprise database with a COBOL DB2 API application. Relational Data Modeling within a business requirement context will be presented. Using a 3270-terminal emulation client, the student will be introduced to SPUFI and QMF to execute SQL batch and static SQL statements. Using DB2I, DCLGEN, ISPF, and SDSF students will code and test COBOL DB2 dynamic SQL interactive applications. The DB2 COBOL application development process, e.g., DB2 Precompile, COBOL load modules, DBRM, packages and plans will be presented. Implementation of cursors, currency, null processing, error handling, basic security and administration will be also presented. Basic SQL DDL commands will be introduced using RDz.
Prerequisite: INFS2130
3 Credits