Standard |
Provides an emphasis on designing and writing programs using the RPG programming language. Topics include: table and array processing, data validation, data structures, interprogram communication, random file access methods, file updating, and interactive processing.
|
Competency Areas |
Hours
|
|
|
|
Table and Array Processing |
Class |
4 |
|
|
Data Validation |
D. Lab |
6 |
|
|
Data Structures |
P. Lab/O.B.I. |
0 |
|
|
Interprogram Communication |
Credit |
7 |
|
|
Random File Access Methods |
|
|
|
|
File Updating |
|
|
|
|
Interactive Processing |
|
|
|
|
|
|
|
|
|
Prerequisite: |
CIS 250 |
||
|
Corequisite: |
|
||
Course Guide |
|
Competency |
After completing this
section, the student will: |
Hours |
||
|
Class |
D.Lab |
P.Lab/ O.B.I. |
||
|
TABLE AND ARRAY PROCESSING |
7 |
10 |
0 |
|
|
Concept |
Explain the concept of one-dimensional tables/arrays including table/array definition within a program using the definition specifications. |
|
|
|
|
|
Develop logical procedures for accessing one-dimensional tables/arrays using a LOOKUP operation code. |
|
|
|
|
Array processing |
|
|
|
|
|
|
Define the rules for the functions available (XFOOT, SORTA, and MOVEA) with an array. |
|
|
|
|
DATA VALIDATION |
2 |
4 |
0 |
|
|
Validation |
Explain the purpose and importance of editing data. |
|
|
|
|
Application |
Write RPG programs that perform validation checks to edit data. |
|
|
|
|
DATA STRUCTURES |
2 |
4 |
0 |
|
|
Concepts |
Explain the requirements of data structures. Break down a field into multiple parts. |
|
|
|
|
Arrays |
Explain concepts of using data structures to create run time arrays. |
|
|
|
INTERPROGRAM COMMUNICATION
|
2 |
4 |
0 |
|
|
Concepts |
Design and implement RPG code to call one program from within another one. |
|
|
|
|
|
Explain the importance of using interprogram communication to access routines that are commonly used. |
|
|
|
|
RANDOM FILE ACCESS METHODS |
8 |
12 |
0 |
|
|
Organization |
Identify differences among sequential, indexed sequential, and direct files. |
|
|
|
|
Specifications |
Describe the K entry to specify that the file is keyed and will be processed using the keyed sequence. |
|
|
|
|
Key definition |
Explain the KLIST and KFLD entries for a concatenated key on the calculation specifications. |
|
|
|
|
Processing |
Describe random record retrieval operation codes such as READ, READE, READP, READPE, SETLL, SETGT, and CHAIN. |
|
|
|
|
|
Select an appropriate record retrieval operation code to allow sequential or random reading of an indexed file. |
|
|
|
|
|
Demonstrate use of positioning within an indexed file using SETxx operation codes. |
|
|
|
|
Application |
Design, code, test, debug, and document programs using random file processing. |
|
|
|
|
FILE UPDATING |
5 |
6 |
0 |
|
|
Sequential and random files |
Explain the interaction between a master file and a transaction file in adding, deleting, and changing records. |
|
|
|
|
|
Explain the use of transaction codes in updating. |
|
|
|
|
|
Describe operation codes for adding, changing, and deleting records. |
|
|
|
|
INTERACTIVE PROCESSING |
14 |
20 |
0 |
|
|
Concepts |
Explain on-line system use. |
|
|
|
|
|
Explain the purpose of inquiries, prompts, and menus. |
|
|
|
|
|
Design effective screen layouts. |
|
|
|
|
Applications |
Design and implement an RPG code that will write to terminal, read from terminal, and access/update disk files in response to on-line requests. |
|
|
|
Suggested Resources |
Yeager, J. (1995). Programming in
RPG/400. Loveland, CO: Duke.
Yeager, J. (1996). Programming in RPG IV. Loveland, CO: Duke.