Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Power Systems Curriculum » IBM i RPG Series

RPG/400 Advanced Workstation Programming

Duration
6 hours

Overview

Description

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 Interactive Programming in a Green-Screen environment.

Prerequisites

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

Objectives

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

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

Course Catalog » Power Systems Curriculum » IBM i RPG Series
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM