- 6 hours
The RPG/400 Advanced Workstation Programming course shows how to use the standard IBM i tools to write and compile RPG/400 programs. This course also covers the design and use of dynamic databases in your program.
Personnel requiring knowledge of RPG Interactive Programming in a Green-Screen environment.
Have completed the Datatrain RPG/400 Workstation Programming Introduction course or equivalent.
After completing the course, the student will be able to:
- Describe how Data is Accessed Using Logical Files, Open Query File, and SQL
- Identify the Tasks used to Configure Your RPG Programming Environment
- Code a Simple RPG Program
Database File Access for Input, Update, and Delete
Advanced Database concepts
Using Data Description Specifications to create a database
Use OPNQRYF to dynamically access a relational database
Use standard SQL statements in your RPG/400 program
Executing the Routines (Writing to the Screen and User Input)
Writing the Record to the File
Avoiding a Program Bug
Control and File Logic Associated with Updating and Deleting a Database Record
Detail the End of Run Processes When the LR Indicator Is ON