Contact | Privacy Policy
YOU CAN! Learn how at the next Summit
March 20-22, 2018 in Dallas
Sponsors & Special Offers
News Headlines
December 12, 2017
RPG & DB2 Summit Opens Up Schedule for Several New Sessions in March
October 20, 2017
Fun photos from the October 2017 RPG & DB2 Summit
August 30, 2017
CIO Summit Planned For IBM i Executives
June 12, 2017
Next RPG & DB2 Summit highlights DB2 for i, Watson's Web Services & Open Source
February 6, 2017
IBM honors Gantner, Paris & Tuohy as 2017 IBM Champions.
December 5, 2016
Summit attendees see tangible results of their education

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 | Conferences | About Us | System i Community | Privacy Policy | Legal Notices | Email Webmaster | Contact
System i Developer,LLC © 2014