Xpanxion/Costco Apprenticeship Capstone Project

The Step IT Up program is a an approved Department of Labor Apprentice Program aimed at bring veterans, women and underserved population to the IT work force. For more details, click here.

For our training, we're focused on learning the technologies surrounding the IBM iSeries, also commonly known as A/S 400, alongside IBM's proprietary language called RPG, and its modern version RPGLE. Our ultimate goal is to showcase technical proficiency to become consultant software engineers for Costco Wholesale Corporation.

STUDENT INFORMATION SYSTEM

The Objective of this project is to create a student information system that will allow the users to create subjects, add courses and students, and view the students' marks(grades).

Technology Used

A/S 400 is not a commonly hosted environment. However, there's a free host called PUB400 that are available for educational purposes.

• Server: PUB400
• Environment: IBM i 7.4
• Languages: RPGLE & SQLRPGLE
• IDE: Rational Developer for IBM i
• Emulator: IBM i Access - Client Solutions 5250 emulator

Getting Started

The entry point to the program is SIS_MAIN.RPGLE. All other RPGLE and SQLRPGLE files are supposed to be compiled as modules, and create service programs for each module.

The copybook for this program is called PROTOTYPE.RPGLE inside the source file QCOPYBOOK. It contains all sub procedure's prototypes, file imports, data structure for display file indicators, and a few subfile related variables

The display file is inside QDDSSRC, named SISDISPLAY.DSPF.

All data related physical files and logical files are the PF and LF in QDDSSRC

These include:

• Users.PF - User credentials for logging in
• StuMaster.PF - Student related information
• StuDetails.PF - Student/subject/marks
• SubMaster.PF - Subject related information
• SemMaster.PF - Semester related information
• CorMaster.PF - Course related information
• SubCourse.PF - Details pertaining each course and what subjects it contains for a specific semester
• ViewStudJF.LF - Logical file joining multiple PFs for the view student detail screen

Entity-Relationship Diagram for the Physical files

Screenshots

Login

Main Menu

Add Subject

Add Course

Add Student

View Students

Acknoledgements

• This project was developed by Steven Wang and Max Ma in November & December 2021
• Our instructor was Vicky Scrubar - LinkedIn
• Our coach was Myra D. Ford - LinkedIn
• Abundance of knowledge and tutorials from Yusuf4Code on YouTube
• Veterans of the United States for their service