Contact | Privacy Policy
Learn how at the next Summit
March 24-26, 2020 in Dallas
Sponsors & Special Offers
News Headlines
February 10, 2020
Session Grid for March 2020 RPG & DB2 Summit features new workshop, new sessions.
February 6, 2020
2020 IBM i Champions Named: Congrats to Ted Holt, Scott Klement, Liam Allan, Alan Seiden, Mike Pavlak, Stephanie Rabbani, Charles Guarino, Susan Gantner, Jon Paris & Paul Tuohy!
December 2, 2019
Super-Saver registration open for March 2020 RPG & DB2 Summit in Dallas!
November 2, 2019
Take a photo tour of the October 2019 Summit in Minneapolis
November 28, 2018
RPG & DB2 Summit heads to Charlotte, NC, with new sessions on SQL, analytics, data integration

Hands-On Workshops

Hands-On: Procedures & 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 the 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. AFter that, we'll move on Service Programs. 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?
  • What are Service Programs?
  • Why you should use them?
  • How to package your procedures into Service Programs
  • Simple ways to update Service Programs

The workshop lectures will be interspersed with hands-on exercises to help cement the principals discussed so far.

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

Hands on: Getting Started with Open Source on IBM i

RPGers looking to get into doing Open Source on IBM i often feel intimidated or overwhelmed at the prospect. Do terms like PASE, SSH, QSHELL, qp2term, bash, PuTTy, RPM and Yum have your head spinning? Confused about where to start?

In this workshop we aim to clear the fog and set you on the path to successfully exploring the world of open source on IBM i.

More details about workshop content will be added soon, including the identities of the mysterious friends who may be joining Mike during the workshop.

Please note: You must bring your own laptop to use during the workshop for hands-on exercises. Information regarding any software that should be pre-loaded and other details will be sent out shortly before the workshop.

Speaker: Mike Pavlak & Friends

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