GEMKO Information Group, Inc.

Information Systems Specialists


Gemko Home Page

GEMKO Anniversary
IBM Capabilities
Microsoft Capabilities



Contact Us

Join Gemko's eNews Mailing List
Enter email address:


21st Century Mid-Range Developer Training Series



RPG has been the preferred choice for development on the IBM iSeries/400 platform. IBM continues to dramatically enhance the iSeries/400 development environment, specifically the RPG IV programming language. GEMKO Information Group has the expertise and capabilities to educate IT professionals in modern RPG IV development and best practices. GEMKO offers a nine track training series entitled, “21st Century Mid-Range Developer Training," which covers the RPG IV language, ILE programming model and other technologies that complement and extend RPG and your business applications (consistent with IBM's System i Developer Road Atlas).

To increase effectiveness, comprehension and reduce the learning curve, the content of our training has been tailored towards leveraging the current skills of traditional developers as the basis for learning modern day technologies and best practices.

Through the utilization of the newly acquired skills and knowledge, it is expected that developer capacity (throughput) will increase, resulting in "doing more with less through efficiency".

____________________________________________________________

21st Century Mid-Range Developer Training Workshops: a nine track training series.
>>Questions? Email info@gemko.com

Training Pricing:
>> Based on number of students and training track selection
>> Click here to request a training proposal

Training Instructor and Subject Matter Expertise:
Christopher F. Burns, Director of Client Systems Modernization, has over 20 years of industry experience including Mid Range technology consulting, application architecture design, systems integration and support. Click here to read Chris' biography!

>> Looking to talk shop with an iSeries subject matter expert? Check out Chris' iBlog!

____________________________________________________________

Track 0 – "Introduction to RPG for Non-RPG Programmers"


Length: 1/2 day

Delivery Method: Instructor led, group-paced, classroom delivery learning model.

Course Description: This workshop prepares students having no RPG knowledge or experience, for the subsequent tracks in this series.

Course Objective: You will learn basic concepts and terminology regarding how the RPG language is used to solve business problems on the System i (AS/400) platform.

Target Student: This course is designed for programmers with experience in other programming languages and basic knowledge of database concepts.

Prerequisites: None.

Performance Based Objectives: Upon successful completion of this course, students will be able to:

  • Understand RPG specific terms used in most training courses, including this series
  • Recognize the components of an existing RPG program
  • Conceptualize the logic flow of new or existing RPG programs
  • Formulate a data access plan for new RPG programs
  • Execute commands to create and manipulate RPG programs
  • Navigate to IBM websites containing reference downloads
Course Content:

  • A brief history of RPG
  • Specifications
  • Terminology primer
  • RPG database processing concepts
  • How to get started
  • Reference sources
____________________________________________________________

Track 1 – Not Your Father’s RPG


Length: 2 days

Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

Course Description: This is an intense RPG programming training workshop which explore the modern RPG language and problem solving methodology on the IBM System i (formerly AS/400), up to and including the latest release.

Course Objective: You will receive sufficient exposure and hands on experience to become productive writing programs in RPG IV right away. Emphasis is on free form style – no fixed form is taught.

Target Student: This course is designed for either programmers experienced in legacy fixed form versions of RPG, or programmers experienced in other languages without any RPG background.

Prerequisites: Track 0 (for non-RPG programmers) or (for established RPG programmers) measurable experience with RPG II (System/36), RPG III (System/38 or AS/400) or fixed form RPG IV (AS/400).

Performance Based Objectives: Upon successful completion of this course, students will be able to:

  • Reduce or eliminate hard coded data definitions in programs
  • Define working storage more strategically to reduce non-productive program tasks
  • Streamline cumbersome calculations with efficient new free form functions
  • Reduce or eliminate the use of numbered indicators
  • Leverage modern data types to perform tasks once relegated to program code
  • Integrate new coding techniques within existing legacy code
  • Introduce syntax and logic flow more consistent with cross platform modern languages

Course Content:

  • High level overview of RPG III vs. RPG IV
  • Evolution of traditional specification types (H, F, I, O)
  • The D specification in detail
  • Freeform calculation specs
  • “Array” of sunshine
  • Some pointers on pointers
  • Old faithful op-codes and new friends
  • Built-in Functions
  • Reference sources
  • Comprehensive labs

    ____________________________________________________________

    Track 2 – Procedures & ILE Programming


    Length: 1 day

    Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

    Course Description: This RPG programming training workshop helps transform the RPG programmer’s way of thinking from traditional to more object oriented. Procedures help make your applications extensible and flexible. The Integrated Language Environment (ILE) allows business logic written in different languages to collaborate and co-exist seamlessly to support enterprise-wide applications.

    Course Objective: You will learn how to leverage the benefits of the ILE architecture by organizing key business logic into tiny granules, such that it is written once and used throughout the application. Students will also learn how to interface with external programs and procedures more reliably.

    Target Student: This course is designed for programmers who have become proficient in the RPG IV language and are seeking to eliminate redundancy and cloning from their applications.

    Prerequisites: Track 1 or comparable experience.

    Performance Based Objectives: Upon successful completion of this course, students will be able to:

    • Create RPG procedures from scratch
    • Build prototypes to interface with procedures and external programs
    • Add flexibility to parameters and return values specified on prototypes
    • Reuse procedures as building blocks for more complex procedures
    • Understand program architecture as defined by the ILE model
    • Organize procedures into service programs (similar to Windows DLL’s)
    • Share procedures with new and existing application programs
    • Implement changes to critical business rules easily throughout the enterprise
    • Further streamline executable code segments
    • Utilize variable scoping

    Course Content:

    • Procedures versus subroutines
    • Local versus global variables
    • Extending the RPG IV function set
    • Prototypes made easy
    • Reduce, reuse and recycle code with ILE
    • Did I say reduce ?
    • Nix the Fix – eliminate the fixed cycle baggage
    • Performance considerations
    • Comprehensive labs
      ____________________________________________________________

      Track 3 – RPG IV and SQL, a 1-2 Punch


      Length: 1 day

      Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

      Course Description: This RPG programming training workshop investigates ways to combine the unique powers of RPG IV and SQL development environments to provide even more flexibility and functionality.

      Course Objective: You will learn how to enable SQL and RPG to complement one another in a business application, especially when one is better suited for a particular task than the other.

      Target Student: This course is designed for programmers who have become proficient in the RPG IV language and are seeking better ways for their applications to harvest data.

      Prerequisites: Track 1 or comparable experience.

      Performance Based Objectives: Upon successful completion of this course, students will be able to:

      • Write SQL queries from scratch
      • Recognize the advantages of SQL over DDS and Query
      • Perform database updates with SQL
      • Access SQL function using several different System/i interfaces
      • Get SQL and RPG to play nicely in the sandbox
      • Make inquiry and report programs more user driven
      • Combine data from multiple files for processing
      • Make informed decisions whether RPG or SQL is better for a given task

      Course Content:

      • SQL crash course
      • Embedding SQL inside RPG
      • Host variables
      • The SQL pre-compiler
      • Using result sets
      • Eliminating “F” specifications
      • Building dynamic SQL
      • SQL works best when you say UNION yes
      • Performance considerations
      • Comprehensive labs

      ____________________________________________________________

      Track 4 – Triggers & API's


      Length: 1 day

      Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

      Course Description: This RPG programming training workshop exhibits how to utilize database triggers, built into DB2, in order to better enforce business rules. API's provide access to System i resources above and beyond those of RPG IV and i/OS.

      Course Objective: You will learn how to give your business logic a more “event driven” design, thus making it less defined by software and more defined by the database itself. Also, how to interface with or manipulate various System i objects via API's.

      Target Student: This course is designed for programmers who have become proficient in the RPG IV and are seeking to improve the integrity of their database, as well as take advantage of more resources available on their System i or other platforms on their network.

      Prerequisites: Tracks 1, 2 or comparable experience.

      Performance Based Objectives: Upon successful completion of this course, students will be able to:

      • Identify opportunities to introduce work flow to their applications
      • Write and apply trigger programs to database files safely
      • Use the trigger buffer strategically
      • Make future trigger programs easier
      • Apply referential integrity rules to database files
      • Test and attempt to violate these rules
      • Interpret documentation in the API Finder
      • Construct prototypes for API's
      • React to API feedback

      Course Content:

      • The concept of work flow
      • How triggers work
      • RPG trigger programs & gotchas
      • SQL triggers
      • Referential integrity on System i
      • Handling rules violations
      • Navigating the API library
      • Interfacing with API's
      • Performance considerations
      • Comprehensive labs

      ____________________________________________________________

      Track 5 – Externalizing Modifications


      Length: 1 day

      Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

      Course Description: This RPG programming training workshop explores ways to utilize System i programming techniques to enhance your 3rd party software without making modifications to their code, thus dramatically simplifying the deployment of new software releases.

      Course Objective: You will learn how to extend the event driven philosophy from Track 4 to include your modification programming efforts, thus getting mods out of the vendor's code and into external objects under your control.

      Target Student: This course is designed for programmers whose workload includes support of 3rd party software and execution of user requests for modifications to those software applications.

      Prerequisites: Tracks 4 and 1,2 or comparable experience.

      Performance Based Objectives: Upon successful completion of this course, students will be able to:

      • Recognize the true cost and risk of modifications
      • Identify mods that are candidates for externalization
      • Identify the principal impact point of a modification
      • Leverage triggers to respond to data base activity
      • Leverage API's to interrogate the run time environment
      • Leverage data queues to respond to spooled file activity
      • Approach screen mods from a different point of view
      • Eliminate the “one mod fits all” traditional strategy

      Course Content:

      • The true cost of modifications
      • Timing is everything – identifying impact points
      • Using triggers and data queues strategically
      • Event driven mods
      • User specific mods
      • Reformatting spooled files
      • Simplifying screen modifications
      • Performance considerations
      • Comprehensive labs

      _________________________________________________________

      Track 6 – Extending to the Web – A “Primer”


      Length: 1 day

      Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

      Course Description: This RPG programming training workshop demonstrates how to utilize IBM supplied tools to bridge the gap between your mission critical RPG business logic and the World Wide Web.

      Course Objective: You will learn how to enable your RPG programs to output to web browsers on a real time basis, and thus generate dynamic web pages with your System i business data.

      Target Student: This course is designed for programmers who are proficient in RPG IV and are looking to provide browser based access to their System i data and legacy RPG business functions.

      Prerequisites: Tracks 1, 2, 4 or comparable experience.

      Performance Based Objectives: Upon successful completion of this course, students will be able to:

      • Create and maintain an Apache server instance capable of running RPG programs
      • Writing static HTML pages from scratch
      • Build HTML forms to communicate with programs
      • Use system API's to interact with the Apache server
      • Modify RPG programs to be launched from and output to web pages
      • Generate dynamic HTML though use of RPG
      • Transform spooled files into browser friendly HTML

      Course Content:

      • Configuring the Apache server on System i
      • HTML crash course
      • Common Gateway Interface concepts
      • Enabling CGI in RPG IV
      • IBM's CGIDEV2 library (and why I hesitate to use it)
      • Web enabling spooled files
      • Performance considerations
      • Comprehensive labs

      ____________________________________________________________

      NEW! Track 7 – Advanced SQL & RPG, The Knockout Punch


      Length: 2 days

      Delivery Method: Instructor led, group-paced, classroom delivery learning model with structured hands-on activities.

      Course Description: This RPG programming training workshop takes the SQL/RPG relationship to the next level, such that RPG may become less the application driver and more the application supported. Since SQL is a cross platform development environment, this will make your applications friendlier to other platforms in your network.

      Course Objective: You will learn how to use SQL to extend your core business logic which is securely rooted in RPG. At the same time, you will be exposed to problem solving techniques that are building blocks to low risk modernization strategies.

      Target Student: This course is designed for programmers who are proficient in both RPG IV and SQL, and are looking to shift some of the application load off RPG and/or modernize that application from its strategic core outward.

      Prerequisites: Tracks 1, 2, 3 or comparable experience.

      Performance Based Objectives: Upon successful completion of this course, students will be able to:

      • Architect database objects to be optimally flexible and compatible with most platforms
      • Perform all database construction with SQL and its graphical tools
      • Apply business rules using SQL
      • Leverage RPG programs as SQL stored procedures
      • Leverage RPG procedures as SQL functions
      • Employ a more object oriented approach to data access in application programs

      Course Content:

      • Saying goodbye to DDS
      • Creating your own data types
      • Building your database the 21st century way
      • Triggers and Constraints the SQL way
      • User defined functions
      • Case study – the standard cross reference
      • Stored procedures
      • Case study – A global item number change
      • Performance considerations
      • Comprehensive labs

      ____________________________________________________________

      NEW! Track 8 – Rational Developer for i Introduction / Primer


      Length: 1/2 day

      Delivery Method: Instructor led, group-paced, classroom delivery learning model.

      Course Description: This workshop introduces students to IBM’s Rational Developer for i software product (RDi) and how it can be used to carry out their daily duties on System i (AS/400).

      Course Objective: You will learn how to get started and be quickly productive with this product. For those who have used IBM’s Programming Development Manager (PDM), how to make the transition gracefully.

      Target Student: This course is designed both for programmers who are new to System i, as well as those who have a wealth of experience with traditional System i tools such as PDM, Source Entry Utility (SEU) and Screen Design Aid (SDA).

      Prerequisites: None.

      Performance Based Objectives:

      Upon successful completion of this course, students will be able to:

      • Understand the strategic advantages of using Eclipse based tools
      • Configure and tailor RDi to their specific environment
      • Utilize the various views and panes within RDi strategically
      • Carry out traditional green screen (PDM) functions in RDi’s graphical environment
      • Create and maintain source code (CL, RPG, etc.) using the LPEX editor
      • Test and debug both batch and interactive programs from within RDi
      • Navigate to IBM reference websites
      • Continue on the learning path

      Course Content:

      • Why re-invent myself now?
      • The Eclipse workbench and RDi
      • One time setup tasks
      • Navigating Remote Systems Explorer (RSE)
      • Source editing
      • Compiling and running
      • Debugging tools
      • Screen Designer
      • Reference sources
      • Optional follow along if hardware and software prerequisites are met

      ____________________________________________________________

      100 Corporate Parkway, Suite 200, Amherst, New York 14226
      716 / 929-2700. Fax. 716 / 929-2705
      webmaster@gemko.com