Day 1 - System i Developer Lectures

Register_Now_Button_2014_06_11_20_00_36.
Paul Tuohy.jpg

Access Client Solutions is a powerful tool for programmers. ACS replaces and enhances much of the functionality originally supplied by Navigator for i.

 

This session discusses how ACS can be used by programmers; including

•   System Configuration

•   5250 Emulator

•   SSH Terminal

•   Integrated File System

•   Printer Output

•   Schemas

•   Run SQL Scripts

•   SQL Performance Center

Paul Tuohy

SiD 1.1 Access Client Solutions (ACS) for Programmers

Paul Tuohy.jpg

In this session, Paul offers a practical guide to handling some of the more esoteric problems in RPG programs (whether using native I/O and Embedded SQL) such as

•         Messaging in a multi client environment

•         Trigger Failures

•         Nulls

•         Constraint Violations

•         Commitment Control

•         And other bits and pieces...

Paul Tuohy

SiD 1.2 Handling the Weird Stuff in RPG Programs

Susan Gantner 2018.jpg

ILE brought with it the topics of procedures, modules, service programs, binding directories and binder language - not to mention activation groups. It can get confusing!

In this interactive session, Susan will walk through a step by step demonstration of the following topics. In the process, we'll discover some of the problems that can occur - what they look like and how to fix or avoid them.

•   Creating a (very) simple RPG procedure in a module

•   How (and why) to put that module into a service program

•   How (and why) to create a binding directory and

•   How to use the binding directory to create programs to use our procedure

•   Add a new procedure to the same module and service program

•   Tips for testing procedures in service programs

•   How to maintain the service program over time - including how to use binder language to avoid signature violations!.

Susan Gantner

SiD 1.3 ILE: Procedures, Modules & SRVPGMs by Example

Paul Tuohy.jpg

You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!

Time to take it to the next stage and see what you can do with embedded SQL - beyond the basics.

Topics covered in this session include:-

• Discussion of the key points in writing powerful embedded SQL

• What tools should you use to write and test SQL prior to embedding it?

• Controlling CRTSQLRPGI

• SQLCA and SQLCODE considerations

• Getting data without SELECT - GET DIAGNOSTICS and VALUES INTO

• Talking to Watson with Embedded SQL

• Mastering Multi Row Fetch

• Handling NULL

• Dates, Times and Timestamps

Prerequisite: This session assumes you are familiar with the basics of embedding SQL into RPG programs, including the use of SQL cursors.

Paul Tuohy

SiD 1.4 Embeded SQL in RPG - Beyond the Basics

Jon Paris 2018.jpg

Over the years Jon has gathered a number of "handy dandy" RPG tips and techniques. In this session he will share some of his favourites, old and new.

 

Topics to be covered include:

•   Useful control (H Spec) options

•   Using compiler directives

•   Searching and Sorting Arrays

•   Using dynamic memory, including teraspace

•   Record Locking techniques

•   Using Data Structures on I/O operations

•   Improved alternatives to KLISTs

•   Using named indicators

•   FEOD without the performance impact

•   And as many more as he has time for!

Jon Paris

SiD 2.1 Jon's Favourite RPG Tips

Susan Gantner 2018.jpg

It's no secret that Susan is a big RDi fan. But even a great tool can be made even better with the help of plug-ins. If you're an RDi user and you don't have the iSphere plug-in installed into your RDi, you're missing out on a wealth of new/enhanced functionality.

Susan will demonstrate a few of her favourite features from iSphere - things such as a better "Find String" capability, tools to make working with message files a breeze and the ability to see text for objects and members in your Remote Systems lists. She will also outline the simple installation process along with some suggestions for how to manage updating iSphere when new releases become available.

Susan Gantner

SiD 2.2 RDi - Even Better with iSphere

Jon Paris 2018.jpg

In recent years IBM has taken a new approach to enhancing RPG. In addition to adding new features to the language, they have also opened the doors to allow us to extend the language into new areas.

 

In the first of these sessions Jon will discuss the first of these new capabilities - Open Access (OA).

 

While these sessions share a common theme, each is an independent session - they do not prereq each other. 

OA provides a mechanism that allows you to simplify how an RPG program interacts with interfaces that the RPG language does not natively support. For example things such as web services, the IFS, data queues, spreadsheets, browsers and more. By using a suitably designed OA handler, your programmers can access such interfaces through native RPG I/O operations (such as READ, WRITE, CHAIN, UPDATE, etc.). They don't have to understand the underlying mechanics, they can simply use their existing RPG skills.

In this session Jon will introduce you to the fundamentals of RPG 's Open Access (OA) by taking you through the process of designing two simple Open Access handlers. In doing so he will introduce you to the OA template that he uses as the foundation for all his OA work.

Jon Paris

SiD 2.3 Extending RPG: With Open Access (OA)

Jon Paris 2018.jpg

In recent years IBM has taken a new approach to enhancing RPG. In addition to adding new features to the language, they have also opened the doors to allow us to extend the language into new areas.

In this second session he will discuss the latest addition to the family - Data-Into.

 

While these sessions share a common theme, each is an independent session - they do not prereq each other. 

DATA-INTO represents IBM's response for requests to provide a JSON equivalent to XML-INTO. Luckily for us IBM resisted the temptation to simply provide JSON capabilities and instead gave us an extensible option for processing any kind of structured data. From JSON to name/value to CSV data - DATA-INTO gives you the ability to handle them all.

In this session Jon will explain the DATA-INTO handlers that IBM provides with the compiler, and  the basics of writing your own handlers. He will also introduce you to Scott Klement's YAJL based DATA-INTO parser for JSON.

Jon Paris

SiD 2.4 Extending RPG: With Data-Into

Register_Now_Button_2014_06_11_20_00_36.