CIS 3340
File Organization and Management Methods
Schedule

CIS 3340 Syllabus

Ketler's Home Page

Programs


Number of Weeks Topic
1
1.5
3.5
  • Test One
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
  • JCL to 
    • Copy a File
    • Delete a File
    • Print a File
1
  • 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 (see above)
    • Sorting and Selecting Valid transactions
      • Review of Using/Giving Sort Options (see above)
      • Review of Input Procedure/Output Procedure Sort Options (see above)
    • Multiple Print Files
      • Error Listing and Audit Trail
1.5
  • Father Son Processing
    • Balance Line Algorithm
    • Modification of the Balance Line Algorithm
      • Include Error Listing
      • Include Audit Trail
    • JCL to create/delete files
  • Data Compression
    • COMP
    • COMP-3
2
  • Passing External Parameters
    • Linkage Section
  • Subprograms
    • The Calling Program
    • The Called Program
    • JCL
      • Create a partitioned data set to store the subprogram for reusability
      • Compile Subprogram
      • Complile Main Program
      • Link MainProgram and Subprogram
      • Executing the Main Program
  • Test Two
1
  • VSAM Files
    • Concepts
    • Sequential, Random, Dynamic Access
    • COBOL
      • SELECT statement options
      • FD layout requirements
      • INVALID KEY option
    • Alternate Index
      • Concepts
      • COBOL requirements for use
    • Status Codes
1
  • VSAM Files
    • Adding records (WRITE)
    • Changing records (REWRITE)
    • Deleting records (DELETE)
  • VSAM utilities
    • Define Cluster
    • Repro
    • Print
    • Delete
    • Listcat
1
  • VSAM utilities
    • Define Alternate Index
    • Define Path to base cluster
    • Build the Index
  • VSAM reorganization (utilities)
    • Export
    • Import
 
  • Final Examination