Contact | Privacy Policy
Learn how at the next Summit
October 15-17, 2019 in Minneapolis
Sponsors & Special Offers
News Headlines
February 6, 2019
2019 IBM i Champions Named: Congrats to Scott Klement, Liam Allan, Alan Seiden, Mike Pavlak, Stephanie Rabbani, Charles Guarino, Susan Gantner, Jon Paris & Paul Tuohy!
November 28, 2018
RPG & DB2 Summit heads to Charlotte, NC, with new sessions on SQL, analytics, data integration
November 9, 2018
Take a photo tour of the October 2018 Summit in Chicago
June 5, 2018
Next Summit highlights SQL, Db2 for i, Open Source
February 6, 2018
New RPG & DB2 Summit Sessions Help IBM i Developers Achieve Big Goals

Hands-On Workshops

Hands-On: SQL for the RPG Programmer!

SQL is being used more and more by the RPG programmer. Not only is SQL replacing DDS for defining databases but it is being used extensively within RPG programs.

This full day hands-on workshop concentrates on the how to code SQL's Data Manipulation Language (SELECT, INSERT, UPDATE, DELETE) and how to embed SQL in RPG programs. There is also an overview of SQL's Data Definition Language (DDL) . It is assumed that the attendee has some basic SQL language experience - such as using interactive SQL to query a table.

Topics include:-

  • Data Manipulation Language (DML)
    • Retrieving Data (SELECT, FROM, WHERE, ORDER BY)
    • Updating Data (INSERT, UPDATE, DELETE
    • GROUP BY, HAVING, Column Functions
    • SQL Functions
    • Selecting From Multiple Tables/Views
  • Embedded SQL
    • Basic Syntax
    • Using host variables
    • Using a SELECT statement
    • Using a Cursor
    • Identifying and handling errors
    • The power of INSERT, UPDATE and DELETE
    • Compile options

Most of the material here is not covered in the main conference. However, there is some overlap in content with the following Summit session, so you may want to choose one of the other 3 sessions in that timeslot:

  • Embedded SQL - The Basics

This is a Bring-Your-Own-Laptop workshop. Information on the software needed to be installed prior to the workshop will be provided in advance of the session.

Speaker: Paul Tuohy

Hands-On: Procedures and Service Programs from A to Z

It has been many years since Jon coded a subroutine. These days he much prefers to use RPG procedures instead. They make great subroutine replacements and make your programs both easier to read and maintain. The result is applications that are faster to build, easier to debug and more reliable.

But procedures are just the beginning. To fully exploit them in your applications you need to package them into Service Programs so that you can share them easily and efficiently among multiple programs.

In this full day hands-on workshop, Jon will explain the advantages of using procedures to modularize your code and show you just how to utilize them to b best advantage.

We will start with the details of coding procedures - the syntax as well as the best practices for using them as a means of structuring your code. Specifically we'll explore such questions as:

  • What's the benefit of return values?
  • Why is local data important?
  • Can prototype keywords make my coding life easier?
  • Why should I code prototypes in a separate member?

The procedure lectures will be followed by a series of hands-on exercises to help cement the principals discussed so far.

Once we have mastered the art of RPG procedures, we will move on to Service Programs. In addition to details on creating and maintaining them, we'll explore:

  • What Service Programs are
  • Why you should use them
  • How to package your procedures into them
  • Simple ways to update them

More hands-on labs will follow the lectures to help you develop "muscle memory" for the required tasks.

We may not make it all the way from A to Z - but we'll give it a try and at least make it all the way to P!

Speaker: Jon Paris

Hands-on: Python Workshop

Python is a language that has been perceived as infrastructure or plumbing in the IT department, much like CL. While this is an excellent use for Python, it has emerged as a strategic language for application development, too.

In this workshop we'll explore the implementation, syntax and application use cases of Python on IBM i. From a fundamentals perspective you will get hands on experience using the command line, shell environment, script creation, storage and execution. As we progress through the workshop we will delve into Db2 data access and program calls using XML Service as well as a brief tour of frameworks. Then we'll wrap things up with how open source applications built in Python can add value to your IT environment.

Please note that you will need to supply your own laptop to participate in the workshop.

Speaker: Mike Pavlak

Hands on: RDi Beyond the Basics

This workshop will take you a few steps beyond the basics of using RDi for developing your RPG code. If you have been using the basic RDi features for editing, compiling and debugging your code, we'll look at some features, shortcuts and customizations that may help take your productivity to the next level.

If you currently have little or no experience with RDi, don't worry. Susan will provide some self-study materials for you to use prior to the workshop to help get you to a point where you can make use of these slightly more advanced topics.

Here are a few of the things we'll cover in this workshop:

  • A review of some of the key new features in recent RDi releases that you may have missed
  • Some well-kept secrets of navigating the Remote Systems lists
  • Hints and tips for customizing your compile options
  • Other customizations to consider to your RDi setup
  • How keyboard shortcuts can speed up your coding tasks
  • Using Templates or Snippets for commonly repeated code
  • Exploiting user actions
  • Creating your own perspectives - how and why
  • Multi-member host search - aka Find String from PDM - 2 options
  • Some non-IBM plug-ins you really should be using

Please note that you will need to supply your own laptop with RDi installed on it to participate in the workshop.

Speaker: Susan Gantner

Home | RPG & DB2 SUMMIT | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2019