YSU CIS 808 - Physical Database File and Program
Course Cis 808-
Pages 2

Unformatted text preview:

Student by Major733-95-2885 Ellis, B. L. ACCTG 80.0500-93-9855 Lemaster, M. W. CIS 108.0CIS 808 Special Topics: AS/400 Lab 2 lab2.docBodnovich Physical Database File and Program page 1 of 2In this lab you will - copy an existing physical database file into your library- use DFU to add records to a database file- modify or code a program to print the contents of a fileUse CPYF to copy the file LAB2DATA (and its member also called LAB2DATA) from the CIS810 library into your own library.Use DFU to add the following 5 records to the LAB2DATA file:SSN NAME MAJOR CREDITS775730902 Young, J. W. CIS 0680870299843 Greene, S. R. CS 1140609838865 Price, G. S. MGT 0480733952885 Ellis, B. L. ACCTG 0800891848933 Randall, E. M. CIS 0960Copy the COBOL program LAB2TEST from QCBLSRC in the CIS810 library to your library. Modify this program to produce a control break report as follows (alternatively you may create your own COBOL,RPG, or C program):Sort the file by name within major (the USING/GIVING option is recommended here).Print a blank line between majors.Hyphenate the SSN.Edit the CREDITS field with 0 suppression and decimal point insertion.CIS 808 Special Topics: AS/400 Lab 2 lab2.docBodnovich Physical Database File and Program page 2 of 2The report should look like the following: Student by MajorSSN NAME MAJOR CREDITS 733-95-2885 Ellis, B. L. ACCTG 80.0 738-09-0355 Hayes, J. T. ACCTG 104.0 500-93-9855 Lemaster, M. W. CIS 108.0 822-94-3034 Pollard, K. S. CIS 103.5 891-84-8933 Randall, E. M. CIS 96.0 832-09-0084 Reynolds, R. N. CIS 165.0 403-98-9309 Watkins, M. L. CIS 88.0 775-73-0902 Young, J. W. CIS 68.0 663-84-7429 Brennan, D. T. CS 78.0 870-29-9843 Greene, S. R. CS 114.0 494-88-0304 Klein, J. S. CS 74.0 930-90-9448 Quinn, T. M. CS 44.0 401-90-1932 O'Connor, B. L. MGT 155.0 609-83-8865 Price, G. S. MGT 48.0 697-93-3531 Zimmerman, C. MGT 128.0Please submit the compilation listing (include your name as a comment in the program) and the report.Due date: Monday, February 14,


View Full Document

YSU CIS 808 - Physical Database File and Program

Download Physical Database File and Program
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Physical Database File and Program and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Physical Database File and Program 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?