Hands-On PHP Workshop
Bring your own laptop and join in the fun as we introduce you to the wonderful world of PHP. Taught from an RPG perspective this full day workshop will give you the confidence you need to get started on your first PHP project.
Information on the software needed on your laptop will be provided in advance of the session.
Speaker: Mike Pavlak
Hands-On RSE/RDi Workshop
Perhaps you've been meaning to say "Goodbye!" to SEU and begin using the modern development toolset for a while, but are concerned about a learning curve. Or maybe you're still on the fence - not sure whether RSE is right for you or worth the investment. Or you may have RSE installed but keep falling back into SEU out of habit or because you're under the gun and you just don't feel comfortable enough with the new tools yet to make the switch.
This full day hands-on workshop is designed to help you get started quickly using RSE and exploiting its productivity features. Susan will provide hints and tips for configuring your first connection. She'll cover her favorite customizations to the workbench and give you pointers on making the most of the RSE features that leave SEU in the dust. You'll get practical hands-on experience with many of those features during lab time. A quick tour of the Debugger and Projects will round out our workshop. You'll leave with a handy keyboard shortcut list, a workbook full of practical tips and, most importantly, the experience of using RSE yourself to get you started on the way to a more productive programming life.
The lecture and labs will be written for RDi - Rational Developer for i V9. Many of the features covered are also available in the older WDSC version of RSE.
Most of the material here is not covered in the main conference. However, there is some overlap in content with the following Summit sessions so you may want to choose one of the other 3 sessions in these timeslots:
- Debugging with RDi
- My Favorite Things about RSE
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. Note that the free trial version of RDi can be used. The free trial version of RDi may be used, so a purchased license is not required for the workshop. But do not install the trial code more than 60 days before the workshop date because once your trial has expired, you cannot re-enable the trial version.
Speaker: Susan Gantner
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.
- 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