Boot Camp Training

Programming in ILE RPG

The ILE RPG Boot Camp provides a convenient way to train new talent in your organization in this programming language. This series consists of 10 video lessons, a workbook, and a save file for the exercises. (The save file is compatible with IBM i release 7.2 and above.) Watch this video for an introduction.

Meet the Speakers

Video Overview

Introduction to Programming and RPG - Hello World Program-Driven

Speaker: Scott Klement

Topics

  • Discuss Series – how exercises work, database file, source code, map the way through
  • Editing Source – with highest level explanation of RDi
  • Identify and Define Program Variables
  • Define Printer File
  • Variable Assignment for “Hello World”
  • Exercise: Print “Hello World” (DSPLY Command – results called from 5250 interface)
  • Compile and Bind Programs
  • Run and Test Programs – show in green screen, WRKOBJ, WRKSPLF, Call
  • Explain Libraries, Explain Objects, Explain Spooled Files – show in green screen
  • Variable Assignment for Add Two Integers
  • Exercise: Add Two Integers (DSPLY Command)

Getting Started - How an RPG Program Is Put Together

Speaker: Kody Robinson

Topics

  • Define Files, Members, Records, Fields
  • Cross-reference with SQL Terminology – schemas, tables, rows, and columns
  • Define and Use Dcl-f (Declare File)
  • Identify Sections of an RPG IV Program
  • Programming Specifications
  • CTL-OPT Keyword
  • Explain Program Development Cycle (short section)
  • Define and Use Dcl-s (Declare Standalone Variable)
  • Define Free Format Specifications
  • Syntax of Writing Comments in RPG (brief)
  • Basic Syntax in RPG – IF, ELSE, ELSEIF, SELECT, WHEN, LOOPS, COMPARISONS, OTHER
  • Monitoring for Errors – MONITOR, ON-ERROR
  • How to Find Reference Manuals
  • Externally Described Files
    • Describe and Use EDTWRD and EDTCDE Edit Codes
    • Define and Use Overflow, SPACEA, SPACEB, SKIPA, SKIPB
    • Use Field Reference File
    • Use WRITE Operation
    • SETLL Operation
    • READ Operation
    • %EOF Function
  • Exercise: Prog1_Documentation (maybe prog3, refer to section above for prog1 & prog2)

Basic Screens

Speaker: Jim Buck

Topics

  • Screens Are a Different DDS
  • Show Keywords
  • Screen Designer in RDi – literals, function keys, input, output, formats
  • Address That Screen from RPG Program – declare and execute formats
  • INDARA, INDDS
  • Outputting onto Screen
  • Exercise: Type YourName, Program Outputs “Hello NAME” Using DSPF
  • CUA (breezy, indicating short overview section)
  • Accessing Individual Records from a File (chain write update)
  • Create a CRUD Program
  • CHAIN
  • UPDATE
  • DELETE
  • %FOUND
  • Using File and Record Locking
  • Exercise: Screen That Asks for Cust Number, Retrieve, Update or Write Back to File – customer maintenance program (CSCTP)
    • Do the exercise in the main program

Using Declarations and Data Structures for File I/O

Speaker: Kody Robinson

Topics

  • Declare and Use Constants
  • Declare and Use Literals (brief)
  • Declare and Use Standalone Variables
  • Declare and Use the LIKE Keyword
  • Declare and Use Data Structures
  • Declaring the Data Structure Header
  • Declare and Use Data Structure Subfields
  • Declare and Use Overlapping Subfields
  • Declare and Use Externally Described Data Structures
  • Declare and Use Qualified Data Structures
  • Declare and Use LIKE and LIKEDS
  • Declare and Use Arrays
  • %LOOKUP
  • SortA
  • %XFOOT
  • Mention Other Types (Compile Time and Prerun Time) of Arrays and Tables to be Found in the Documentation
  • Data Structure Arrays
  • Assign Initial Values to Variables
  • Initialize Data Structures and fields
  • Exercise: Split Phone Number Area Code from Exchange, Look Up the Full State Name from the Two Character Code Using an Array (CSCSTP)
  • Introduction to Data Structures as a Mechanism for Passing Info to and from File
  • LIKEREC Keyword, *input, *output
  • Using Data Structures with Database
  • Using Data Structures with Display Files
  • INDDS Keyword
  • EVAL-CORR
  • Exercise: Redo CRUD Application with Data Structures for File I/O (CSCSTP)

Controlling Program Workflow - Subroutines and Subprocedures

Speaker: Jim Buck

Topics

  • Using Relational Comparisons – >, =>, =, <=, <, <>
  • Define and Use Sequence
  • Define and Use Selection
  • Declare and Use IF, ELSE, ELSEIF
  • Declare and Use SELECT, WHEN, OTHER
  • Define and Use Control Break Logic (not using the cycle)
  • Declare and Use Iteration
    • Declare and Use DOW Operation
    • Declare and Use DOU Operation
    • Declare and Use FOR Operation
  • Loops and Early Exits
    • Declare and Use ITER Operation
    • Use the LEAVE Operation
  • Declare and Use Subroutines
    • Use the BEGSR, ENDSR Operation
    • Use the EXSR Operation
    • Use the LEAVESR Operation
  • Declare and Use Subprocedures
    • Declaring local variables
    • Parameters
    • Return Values
    • Passing Parameters by Value
  • Calling Programs
    • Parameters
    • Prototypes
    • Calling the Prototype
  • Exercise: CRUD Application in Different Routines, Pass the Data Structures as Paramaters (CSCSTP)
  • Exercise: Report That Does Control Breaks (CSCTP) Total Balance Due by State

ILE Concepts

Speaker: Scott Klement

Topics

  • Exporting Subprocedures
  • Define Binding
  • Cycle Main vs No Main vs Linear Main Procedures (breezy)
  • Modules
  • Use the /COPY, /INCLUDE Statements
  • Compile and Bind Modular Programs
  • Exercise: Redo CRUD Program Using Modules, Read, Write/Update, and State Lookup into Separate Modules (CSCSTP)
  • Describe Single Entry Point Programs
  • Describe Multiple Entry Point Service Programs
  • Use Binding Directories
  • Compile and Bind Service Programs
  • Describe and Use Binder Language
  • Describe and Use Service Program Signatures
  • Use the CRTSRVPGM command
  • Deploy Service Programs in an Application
  • File I/O and Subprocedures
  • Use the DSPPGM and DSPSRVPGM Commands (breezy)
  • Activation Groups
    • Describe and Use the Default Activation Group
    • Describe and Use a Named ILE Activation Group
    • Describe and the Caller’s Activation Group
    • Describe and Use Activation Groups and File Overrides
    • Describe and Use Activation Groups and File Opens
  • Exercise: Redo CRUD Program Using Service Programs (CSCSTP)

Static SQL

Speaker: Patrick Behr

Topics

  • Define SQL Data Manipulation Language (DML)
  • Define and Use DML Statements Select, Inset, Update and Delete
  • Define and Use EXEC-SQL
  • Using Host Variables in SQL statements
  • Define and Use Host Structures
  • Handle Null Values in Tables Use the SQL
  • Handle SQL Return Codes (SQLCODE and SQLSTATE)
  • Define and Use SQL Cursors
  • Use the SQL OPEN Statement
  • Use the SQL FETCH Statement
  • Use the SQL CLOSE Statement
  • Use the SQL UPDATE Statement
  • Use the SQL DELETE Statement
  • Use the SQL SET OPTION Statements (ALWCPYDTA, CLOSQCLCSR)
  • Create a SQLRPGLE Program
  • Exercise: Redo CRUD Application Using SQL (CSCSTP), Take Service Program and Redo with SQL-based Service Program

Further Operations and Functions

Speaker: John Fellner

Topics

  • How to Look Up Functions in the Manual (knowledge center)
  • Demonstrate Going Down List and Picking a Function
  • Explain the Documentation for One of the Functions (fixed, free, factor 1, 2, and result)
  • How to Look Up Op Codes in the Manual
  • Demonstrate Going Down List and Picking an Op Code
  • Explain the Documentation for One of the Op Codes (fixed, free, factor 1, 2, and result)
  • Using Op Codes and Functions in Calculations
  • Numeric Examples
    • %EDITC
    • %DEC, %DECH (plus discussion of half adjust)
    • %REM
  • String Examples
    • %SUBST
    • %CHAR
    • %SCAN
    • %CHECK
    • %XLATE
    • %TRIM (%TRIMR, %TRIML)
  • Date Examples
    • %DIFF
    • %SUBDT
    • %DATE, %YEAR, %HOUR (different date and time formats discussed)
  • Exercise: CSCSTP Table – Write Procedure to Convert to Proper Case (%SUBST and %XLATE) and Flag if Last Order Date within X Days (%DATE and %DIFF)

Programming with Subfiles

Speaker: Max Valdman

Topics

  • Subfile Record Format
  • Define and Use the SFL Keyword
  • Subfile Control Record Format
  • Define and Use the SFLCTL Keyword
  • Define and Use the SFLDSP, SFLDSPCTL Keywords
  • Define and Use the SFLPAG, SFLSIZ Keywords
  • Define Footer Record Format
  • Define and Use the OVERLAY Keyword
  • Load a Subfile
  • Load an Entire Subfile
  • Load a Subfile a Page at a Time
  • Expanding Subfile
  • Reloading a Subfile after Delete or Sort
  • Getting Input from Subfiles
  • Define and Use the READC Statement
  • Define and Use the Chain Op Code
  • Exercise: Create Order Entry Application (CSCSTP, CSINVP, CSORDP, CSORDPRP)

Additional SQL Techniques

Speaker: Ray Everhart

Topics

  • Dynamic SQL vs Static SQL Use Sases
  • Use the SQL PREPARE Statement
  • Use the SQL EXECUTE Statement
  • Using Prepare with Cursors
  • Reserved Variable Names
  • Exercise: Convert Report Application to a Subfile SQL – Dynamically Control How Sorted Based on Parameter (CSCSTP)
  • Commitment Control – Why It Is Important
    • Commitment Scope
    • Rollback and Commit Statements
    • Set options statement for defining commit options
  • Exercise: Order Entry Application with Commitment Control (CSCSTP, CSINVP, CSORDP, CSORDPRP)

Subscriptions

An individual subscription to one of the Boot Camp video training series is $699/Member and $849/Nonmember.

Individual Subscription

Site licenses are available for three or more individuals from the same organization. The subscription cost is $1899/Member and $2249/Nonmember.

Site License

All individual subscriptions and site licenses are valid for one year. Renewals are available at a 50% discount by calling us at 312-279-0192 or 800-777-6734.