Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

RPG/400 Advanced Workstation Programming

Duration

6 hours

Overview

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.

Audience

Personnel requiring knowledge of RPG/400 programming in a Green-Screen Environment

Prerequisites

Have completed the Datatrain RPG/400 Workstation Programming Introduction course or equivalent.

Objectives

    After completing this 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

Course Content

Subroutines

Subroutines
Database File Access for Input, Update, and Delete

Advanced Database and SQL Programming

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

Programming Environment

Executing the Routines (Writing to the Screen and User Input)
Writing the Record to the File
Avoiding a Program Bug

Programming Specification and Documentation

Control and File Logic Associated with Updating and Deleting a Database Record
Detail the End of Run Processes When the LR Indicator Is ON

RPG/400 Advanced Workstation Programming Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120