CIS3340

CIS 3340
File Organization and Management Methods
Schedule

Week	Topic
1	Sequential File Processing Father-Son Processing (Creating a new version) Updating in Place (Rewriting) Updating in Place (all records) Rewrite Statement Open IO Sample Program Audit Trail File Backups Program 1 Discussion JCL to Copy a File Delete a File Print a File
2	Updating in Place (records selected with transaction file) Transaction File Matching Transaction File and Master File Multiple transactions for one file Review of Control Break Logic Sorting and Selecting Valid transactions Review of Using/Giving Sort Options Review of Input Procedure/Output Procedure Sort Options
3	Updating in Place - Multiple Print Files Error Listing and Audit Trail Review of Positional (Direct tables) tables Program 2 Discussion
4	Sample Father Son Processing Balance Line Algorithm see textbook figure 17.7 Modification of the Balance Line Algorithm see textbook figure 17.11 Sample balance line program Include Error Listing Include Audit Trail JCL to create/delete files Program 3 Discussion
5	Data Compression (Program) Data Compression (Print Dump) Example 2 COMP COMP-3 Blocking Factors Lab Day
6	Assign Program 4 Modified Balance Line Algorithm Compressed Data Review of Variable Length [Input loaded] Tables See Cobol I page: www.ux1.eiu.edu/~cfkjk/index7.html Sorting Data in Tables Bubble Sort/Insertion Sort
7	TEST
8	Program 5 Discussion Passing External Parameters Linkage Section
9	Subprograms The Calling Program The Called Program JCL Create a partitioned data set to store the subprogram for reusability Compile Subprogram; Second subprogram Complile Main Program Link MainProgram and Subprogram (see JCL at bottom on main program) Executing the Main Program Program 6 Discussion
10	VSAM Files Concepts Sequential, Random, Dynamic Access COBOL SELECT statement options FD layout requirements INVALID KEY option
11	VSAM Files Alternate Index Concepts COBOL requirements for use Status Codes Program 7 Discussion
12	VSAM Files Adding records (WRITE) Changing records (REWRITE) Deleting records (DELETE) VSAM utilities Define Cluster Repro Print Delete Listcat
13	VSAM utilities Define Alternate Index Define Path to base cluster Build the Index VSAM reorganization (utilities) Export Import
14	Two Dimensional Tables (review) Review for Test
15	Test Review for Final Examination