INFS6242-A Enterprise Database Systems    (Spring 2014)

Course Details
Course Description
About The Instructor
Course Details

Session, Dates: 1 (01/13/2014 - 05/03/2014)

Days: W

Time: 06:00 - 08:50 pm

Location: Moon Campus

Room: Hale Center 102

Seats Available: 5 Seats

Credits: 3

Course 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: INFS6130

About The Instructor

J. Packy Laverty, Ph.D.
Professor of Computer and Information Systems
 Computer and Information Systems

laverty@rmu.edu
412-397-6477 phone
412-397-6469 fax
Wheatley Center 310

Profile



ROBERT MORRIS UNIVERSITY

6001 University Blvd. Moon Township, PA15108 800-762-0097 © 1995 – 2011 Robert Morris University. All rights reserved.