SPEAKING SESSIONS & WORKSHOPS
Train current staff on the latest IBM i tools and techniques. Hold an event to learn more all that imPower can help create for your power team.
Non-Technical Presentations
Education – How to Remain Relevant in a Changing IT Environment
Education in today’s IT and Business Environment challenges both the Company and the employee. What skills are needed to provide for today’s (and tomorrow’s) business needs? How does the company and the employee deal with these challenges? How to decide; what...
Modernization and 21st Century Skills
How to Move your Business into the 21st Century on IBM i Faced with pressure from upper management, learn how different companies moved their company's software into the 21st century. Why 21st century technologies, require systematic training. We will discuss the...
Failure to Modernize – The Real Cost
In 2008; Jim wrote an article for COMMON called the “A Perfect Storm” This article discussed the low enrollment rates for Information Technologies classes in the United States. Fast forward to 2016, Information Technology education in colleges has made a comeback. Now there is a shortage of qualified young IT professionals with enterprise skills.
Technical Presentations
Processing JSON with DB2 and RPG
IBM has done some great things that allow DB2 to process JSON objects. This session shows you “Tips and Tricks” to make your life easier when you start working with JSON data. After a short discussion of the HTTP functions that have been added to SYSTOOLS and how they can be used with the JSON_TABLE Function, Jim shows the attendee how to work with the SYSTOOLS.HTTPGETCLOB and JSON_TABLE Functions to consume an API returning a JSON object. If you have tried using these functions many have problems writing the correct SQL/JSON path expressions to extract the data and represent it in a relational table. Jim will help the attendee understand this process with solid examples.
Technical Presentations – RDi/RPG/SQL Session Series
An Attendee can attend one or more of these sessions. The goal of the three sessions is to show an attendee the steps needed to take a 5250 application, convert it to use procedures and SQL access, then use the completed SQL Service program to provide web services that can be consumed by other platforms and languages.
Session One: What’s the Fuss? – Using Procedures and Service Programs
This session discusses the advantages of using modern techniques in your RPG programs. After a short introduction to modularity in programming; we go step-by-step through the process of replacing called programs with sub-procedure modules and then converting these modules to procedures in a called service program.
Session Two: Darn… Cursed Again! – Using SQL & Cursors in your Programs
This session demonstrates the use of SQL in your programs. After a short discussion of the differences between Dynamic and Static SQL in your programs; we demonstrate the important concepts in creating a robust SQL program. Topics include host variables, data-structures, error trapping and using tables with SQL.
Session Three: So Now What? – Using Integrated Web-Services Server and Service Programs
This session shows how a service program that was originally used for a 5250 application can be used to create a web-service. In this presentation, we will work through the steps required to make a number of web-services using a service program, install the web-services on the IBM Integrated Web Services Server and consume the web service using PHP and Java.
Workshops
Half Day RDi/RPG Hands-On Lab
This combined lecture and lab will show the attendee how a Screen/Report program can be driven by an SQL Service program that handles the database I/O. By decoupling the screen/report output from the database, the service program may be used as a web service. The...
Half Day Consuming API’s with JSON and RPG Hands-On Lab
Session Abstract The use of API's developed by other companies can easily give a company benefits that would be difficult or impossible to develop inhouse. The number of API's available for companies to consume is endless. This workshop will show the attendee how to...
All Day RDi/RPG Hands-On Bootcamp
This combined lecture and lab will show the attendee how to take a traditional subfile program and convert the disk I/O to SQL then move this database I/O to a service program. This decoupling of the UI (5250 Subfile) allows the service program to be used as a web service. The session will take the attendee through the process of developing a SQL/Service program based CRUD application using Free Form RPG and RDi’s (Remote Systems Explorer and Screen Designer).