152-116 RPG-Intermediate

This is a continuation of Beginning RPG. Topics include arrays, display files, file maintenance and procedures. Students will also be exposed to embedded SQL.

Prerequisite:
   RPG Beginning
   Introduction to the iSeries.

• Syllabus



• Schedule

• Unit 1 Tables and Arrays
• Chapter 9 Presentation


• Unit 2 File Maintenance
• Chapter 10 Presentation


• Unit 3 Interactive Inquiry
• Chapter 11 Presentation


• Unit 4 Procedures
• Chapter 12 Presentation
• Chapter 13 Presentation


• Unit 5 Embedded SQL
• Embedded SQL Presentation


• Program Standards



• Input


• Display Screen Layout

• Check offs
• Chapter 9: 4-7 A & T
• Chapter 10:1 & 4
• Chapter 11:R11C1xxx
•                   R11C2xxx
• Chapter 12:2 & 3
• Chapter 13:1a & 1b
• SQL


• Assignments
• Chapter 9 Worksheet
• Chapter 10 Worksheet
• Chapter 11 Worksheet
• Chapter 12 Worksheet
• Chapter 13 Worksheet


• Programs
• Chapter   9: Program 1
• Chapter 10: Program 2
• Chapter 12: Program 3
• Chapter 13: Program 4