RPG Bootcamp

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.

  • RPG Bootcamp: Exercise Workbook and IBM i Save File

    Contains 2 Component(s)

    Exercises and Save File

    Access the exercise workbook and IBM i save file here

  • RPG Bootcamp Session 10: Additional SQL Techniques - Ray Everhart

    Contains 1 Component(s)

    RPG Bootcamp Session 10

    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)

    Ray Everhart

    Product Manager, X-Analysis, Fresche Solutions

    Product Manager, X-Analysis, Fresche Solutions

  • RPG Bootcamp Session 9: Programming with Subfiles - Max Valdman

    Contains 1 Component(s)

    RPG Bootcamp Session 9

    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)

    Max Valdman

    IT Manager, The Hammock Source

    Max Valdman is an IT professional with an MBA and BS in Mechanical Engineering and over 20 years of IT experience, primarily in the Consumer Goods industry. He is currently an IT Manager for the world’s largest hammock manufacturer, The Hammock Source. Max is an active member of the Mid-Atlantic Group of IBM i Collaborators – MAGiC and serves on the Advisory Committee of HarrisData, an enterprise software application company. Max and his family are enjoying the climates of Eastern North Carolina and Greenville, home of the ECU pirates.

  • RPG Bootcamp Session 8: Further Operations and Functions - John Fellner

    Contains 1 Component(s)

    RPG Bootcamp Session 8

    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)

    John Fellner

    Independent Software Consultant

    John Fellner is an independent software development consultant for the IBM i and Windows platforms. For many years he did software development and support at the IBM Toronto Lab in the AS/400 / iSeries / IBM i RPG Compilers and Developer Tools area.

  • RPG Bootcamp Session 7: Static SQL - Patrick Behr

    Contains 1 Component(s)

    RPG Bootcamp Session 7

    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

    Patrick Behr

    Patrick Behr has been working on IBM i and its predecessors for 20 years, with a focus on RPG and DB2. Patrick has worked for large retail companies like Costco and Starbucks, manufacturing companies, small businesses and the government.

    Patrick lives with his wife in Southern California and enjoys the many outdoor activities that the area affords, including kayaking, rock climbing and surfing. He and his wife also volunteer for local animal rescues and have fostered more than 700 dogs so far.

  • RPG Bootcamp Session 6: ILE Concepts - Scott Klement

    Contains 1 Component(s)

    RPG Bootcamp Session 6

    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)

    Scott Klement

    Director, Product Development and Support

    Scott Klement is the Director of Product Development and Support at Profound Logic Software, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers. His efforts to help programmers have earned him many accolades and awards. In 2012, IBM named Scott an IBM Champion for Power Systems. In 2018, Scott was elected to COMMON's Board of Directors.

  • RPG Bootcamp Session 5: Controlling Program Workflow - Subroutines and Subprocedures - Jim Buck

    Contains 1 Component(s)

    RPG bootcamp session 5

    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

    Jim Buck

    imPower Technologies

    Jim Buck’s career in IT has spanned more than 35 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM and COMMON certification tests. Jim has co-authored several IBM i books with Bryan Meyers that are used by many companies and in colleges worldwide, "Programming in ILE RPG" 5th Edition being the latest in 2015.Other accomplishments include; recipient of the 2007 IBM System i Innovation – Education Excellence Award, 2014 COMMON Presidents Award and named 2013/2016/2017 IBM Champion - Power Systems.Jim is the president and founder of imPower Technologies where he provides professional IBM I training and consulting services (www.imPowerTechnologies.com) . He is active in the IBM i community working to help companies train their employees in the latest IBM technologies and helps companies develop the next generation of IBM i professionals.

  • RPG Bootcamp Session 4: Using Declarations and Data Structures for File I/O - Kody Robinson

    Contains 1 Component(s)

    RPG bootcamp session 4

    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)

    Kody Robinson

    Business and Financial Systems Developer, AECC

    Kody Robinson is a Business and Financial Systems Developer for AECC, headquartered in Little Rock, AR. He started his IBM i journey right out of undergrad at the age of 21. Kody develops and modernizes old and new applications for internal clients using languages ranging from RPG free-format to PHP. Along with his day job, Kody also travels and advocates for IBM and COMMON in regards to companies modernizing and hiring young developers in the work force. IBM has also named him an IBM Champion for Power. In between that, helping with nonprofits and finishing up his masters in Information Science, he also does Economic Development for Central Arkan

  • RPG Bootcamp Session 3: Basic Screens - Jim Buck

    Contains 1 Component(s)

    RPG Bootcamp Session 3

    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

    Jim Buck

    imPower Technologies

    Jim Buck’s career in IT has spanned more than 35 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM and COMMON certification tests. Jim has co-authored several IBM i books with Bryan Meyers that are used by many companies and in colleges worldwide, "Programming in ILE RPG" 5th Edition being the latest in 2015.Other accomplishments include; recipient of the 2007 IBM System i Innovation – Education Excellence Award, 2014 COMMON Presidents Award and named 2013/2016/2017 IBM Champion - Power Systems.Jim is the president and founder of imPower Technologies where he provides professional IBM I training and consulting services (www.imPowerTechnologies.com) . He is active in the IBM i community working to help companies train their employees in the latest IBM technologies and helps companies develop the next generation of IBM i professionals.

  • RPG Bootcamp Session 2: Getting Started - How an RPG Program Is Put Together - Kody Robinson

    Contains 1 Component(s)

    RPG bootcamp session 2

    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)

    Kody Robinson

    Business and Financial Systems Developer, AECC

    Kody Robinson is a Business and Financial Systems Developer for AECC, headquartered in Little Rock, AR. He started his IBM i journey right out of undergrad at the age of 21. Kody develops and modernizes old and new applications for internal clients using languages ranging from RPG free-format to PHP. Along with his day job, Kody also travels and advocates for IBM and COMMON in regards to companies modernizing and hiring young developers in the work force. IBM has also named him an IBM Champion for Power. In between that, helping with nonprofits and finishing up his masters in Information Science, he also does Economic Development for Central Arkan