152-116 RPG-Intermediate

This is a continuation of Beginning RPG. Topics include display file, logical files, subfiles and printer files. 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
• Chpater 14 Presentation


• Unit 5 Embedded SQL
• SQL Presentation


• Program Standards



• Input


• Display Screen Layout


• Process


• Output

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


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


• Programs
• Chapter 9: Program 1
• Chapter 10: Program 2
• Chapter 11: Program 3
• Chapter 12: Program 4
• Chapter 13: Program 5
• Chapter 14: Program 6