INFS 4242 - ENTERPRISE DATABASE SYSTEMS

Institution:

Robert Morris University

Subject:

Computer Information Systems

Description:

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

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.rmu.edu

Phone Number:

(800) 762-0097

Regional Accreditation:

Middle States Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.