Contact | Privacy Policy
Learn how at the next Summit
March 24-26, 2020 in Dallas
Sponsors & Special Offers
News Headlines
April 9, 2019
Take a photo tour of the March 2019 Summit in Charlotte!
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
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

Procedures and Service Programs from A to Z

Susan doesn't write subroutines any more. These days she prefers using 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, Susan 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?
  • What prototype keywords can 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 to P!

Note: This is a Bring-Your-Own-Laptop workshop. Below is a high level look at the requirements for your laptop. More details of these requirements will be sent out to attendees just before the Summit.

  1. You must bring a laptop in order to do the hands-on labs that are an essential part of the workshop.
  2. Your laptop must have some form of "green screen" 5250 emulator (e.g., ACS, TN5250, IBM i Access, etc).
  3. Your laptop must provide access to your RPG programming editor of choice (e.g., RDi or PDM/SEU).
  4. Your laptop must be able to connect via wifi to a host IBM i system outside your office network.

Speaker: Susan Gantner

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: Intermediate SQL for RPG Programmer

You have been been getting to grips with SQL and how to use SQL in RPG programs. You know how to make use of powerful SELECT statements and have even used INSERT, UPDATE and DELETE statements to manipulate data in the database.

In this hands-on workshop, Paul helps you to bring your SQL and embedded SQL to the next level. Topics covered include...

  • Introduction
  • Functions of Note
  • Grouping Sets
  • Using CASE
  • Sub Queries
  • Common Table Expressions
  • Union
  • Identity Columns
  • Row Change Timestamp
  • The Importance of Views
  • Controlling CRTSQLRPGI
  • SQLCA and SQLCODE considerations
  • Getting data without SELECT
  • Multi Row Fetch
  • Paging Cursors
  • Position To
  • Handling NULL
  • Dynamic SQL

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 - Beyond 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

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