BCIS 4620 – Spring 2009

Assignment #4: NetExpress COBOL w/SQL

(BONUS: 10 points)

DUE: Feb 25, 2009 -- prior to your class period.

======================================================================

Please create one report using the NX COBOL environment with embedded SQL statements. Use the COBOLSQL program from the earlier COBOL assignment as a "shell" for this assignment. Use the REFRESHed (original) form of EMP, DEPT for database input. You may create your own VIEWs of the database as needed.

REPORT DESCRIPTION: A control break report listing all employees sorted by department name (ascending order), job title (ascending order), employee name (ascending order—last name, first name).

REPORT REQUIREMENTS:

- Appropriate Title and column headings. For each person, you will provide the employee last and first names, department code, department name, job, date hired, and total compensation. Total compensation equals (salary + bonus + commission).

- Appropriate report break headings including department name.

- Also compute and print subtotal of total compensation by department name and a final total compensation for all departments.

- The reports must show run date. Page numbers are required.

- There must be at least two numbered pages of report output.

TURN IN:

1. The OUTFILE (printed report using NX/SQL)

2. The COBOL program printout prior to compile (COB.SQL file)

3. The COBOL program file and any related datasets, see below (on a floppy disk or equivalent).

4. Print SQL files used to create any "VIEW"s used in the COBOL program. This is OPTIONAL; however, if you created your own VIEW outside COBOL program, it is REQUIRED)

HINTS: The only input (file) to this program is data from the NX/SQL database. The only output is the report.

Specifications:

- Appropriate Title and column headings. For each person, you will provide the employee last and first names, department code, Department name, job, date hired, and total compensation. Total compensation equals (salary + bonus + commission).

- Appropriate report break headings including department name.

- Also compute and print subtotal of total compensation by department name and a final total compensation for all departments.

- The reports must show run date. Page numbers are required.

- There must be at least two numbered pages of report output.

SAMPLE REPORT LAYOUT

Title

Date xx/xx/xxxx Page No. xx

Department Name: XXXXXXXXXXXXXXXXXX

Employee Name Department Code Job Date Hired Total Compensation

Xxxxxxxxxx, xxxxxxxx xxxx xxxxxxx xx/xx/xx $xx,xxx.xx

Xxxxxxxxxx, xxxxxxxx xxxx xxxxxxx xx/xx/xx $xx,xxx.xx

Xxxxxxxxxx, xxxxxxxx xxxx xxxxxxx xx/xx/xx $xx,xxx.xx

Xxxxxxxxxx, xxxxxxxx xxxx xxxxxxx xx/xx/xx $xx,xxx.xx

Subtotal Compensation for Department XXXXXXXXXXX $xxx,xxx.xx

[Following line on last page ONLY]

Total Company Compensation $x,xxx,xxx.xx