Welcome to my Mainframe Projects repository! 🚀 This is where I showcase my skills and projects related to Mainframe technologies, including COBOL, JCL, and SQL. These scripts highlight my ability to work with legacy systems while building a strong foundation for enterprise applications.
This repository is organized into three main folders:
- COBOL: Programs demonstrating COBOL basics, file handling, and more.
- JCL: Scripts to execute and manage batch jobs.
- SQL: Queries for data manipulation and analysis.
-
File Processing with Sorting (
sort_employees.cobol):- A COBOL program that sorts employee data by salary and writes the sorted output to a new file. It demonstrates file handling and sorting techniques.
-
Report Generator (
employee_report.cobol):- Generates a summary report of employees with salaries exceeding a specified threshold. It showcases conditional logic and report generation.
-
Conditional Execution (
conditional_execution.jcl):- Executes a COBOL program and conditionally runs a secondary step based on the success of the first step.
-
VSAM File Management (
vsam_file_management.jcl):- Defines and loads a VSAM KSDS (Key-Sequenced Data Set) using IDCAMS, demonstrating dataset management.
-
Employee Data Insights (
employee_data_insights.sql):- Retrieves employees with salaries above their department average. Demonstrates subqueries and aggregation.
-
Monthly Sales Report (
monthly_sales_report.sql):- Calculates total sales for each product category for the current month. Demonstrates grouping and aggregation.
- COBOL: Structured programming, file handling, and record processing.
- JCL: Batch job management, dataset handling, and execution.
- SQL: Data retrieval, filtering, aggregation, and reporting.
Hi, I’m Ashley! ✨ I’m passionate about bridging legacy and modern technologies, and this repository reflects my journey in mastering Mainframe skills. Feel free to explore my projects and connect with me!