Loading…
COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall

Log in to bookmark your favorites and sync them to your phone or calendar.

RPG [clear filter]
Monday, October 15
 

10:45am

13AH SQLRPGLE: The Better File Access
We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process with embedded sql. How to handle sql exceptions. And finally, how can you leverage SQL to replace your current record level access.

Learning Objectives:
Overview of embedding sql in your RPG programs. How to streamline sql procedures with the use of a SQL utility service program. how to modernize your current record level access to use embedded sql

This is Session ID:180307

Speakers
avatar for Marina Schwenk

Marina Schwenk

Software Developer, Everbrite
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a developer in both RPG and Java and she also is one of two junior IBM... Read More →


Monday October 15, 2018 10:45am - 11:45am
Marquis Ballroom C

4:00pm

17AH A Nerd's Guide to DATA-INTO in RPG
RPG's DATA-INTO opcode is a powerful tool for mapping data from documents (such as JSON, XML, CSV, etc) into RPG variables. DATA-INTO works together with a separate program, known as a "parser" that interprets the data format. In this session, Scott will explain the basics of using DATA-INTO, first by showing how to use it with an existing parser, then he will provide the really nerdy stuff: How to write your own parser!


Learning Objectives:
1. What RPG's DATA-INTO opcode? When is it useful?
2. How to use it with an existing parser program.
3. How to write your own parser program


This is Session ID:180257

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Monday October 15, 2018 4:00pm - 5:00pm
Marquis Ballroom C
 
Tuesday, October 16
 

1:30pm

25AD POWER PICK: Working with JSON in RPG with YAJL
JSON (JavaScript Object Notation) is quickly becoming an important document format for business data interchange, so what's the best way to process it from RPG? JSON provides the same benefits as XML, but is smaller (and so transmits over a network more quickly) and is much more efficient than XML to work with in web applications. Naturally, this means that your RPG business applications need to learn how to speak JSON in order to talk to many of the newer web services or exchange data with many tech-savvy business partners. In this session, Scott will explain how the open source YAJL tool can be used from an RPG program to process JSON with the DATA-INTO opcode, directly with YAJL's API and generate JSON with YAJL.


Learning Objectives:
1. Basic introduction to JSON format
2. How to generate a JSON document in RPG with YAJL
3. How to read a JSON document in RPG with DATA-INTO
4. How to read a JSON document in RPG with the YAJL API


This is Session ID:170320

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
Grand Ballroom 5

1:30pm

25AH 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.


Learning Objectives:
1. Internalize the benefits of using modular coding practices
2. Develop reusable subprocedures and service programs
3. Understand the steps in coding modular subprocedures and service programs


This is Session ID:170340

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), imPower Technologies
Jim Buck’s career in IT has spanned more than 35 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Tuesday October 16, 2018 1:30pm - 2:30pm
Marquis Ballroom C

2:45pm

26AH Finally – RPG Freed from the Fetters of Fixed Format
Finally! The time where RPG was a cryptic, column oriented, hard to decode programming language is over. Beginning with release V5R1M0 free format coding for C-Specs was introduced … but it took until release 7.1 TR 8 (respectively release 7.2) until the H, F, D and P-Specs got a free format equivalent. The complete free format coding includes several simplifications and/or assumptions, for example if not explicitly defined differently a file (F-Spec) is handled as input file. Instead of single characters that had to be coded on a specific position, descriptive keywords are introduced, for examples specific keywords exist for all data types. The sequence of F- and D-specs is no longer mandatory. And with release 7.2 TR 3 the last restriction (RPG source code has to be coded between position 8 and 80) is removed.

Learning Objectives:
In this session you will learn how to code free-format H-, F-, D- and P-Specs beginning with the new DCL-Opcodes, continued with the new keywords for defining data types in stand-alone fields or data structure sub-fields. This session will cover the file definition for keyed or unkeyed access in input and update mode. You’ll also learn how to define all kinds of work fields, constants, arrays, (nested) data structures etc. The coding of (sub-) procedures, prototypes and procedure interfaces are demonstrated as well as the coding of special data structures, such as program status data structure and data areas.

This is Session ID:170060

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Fresche Solutions, Inc.
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday October 16, 2018 2:45pm - 3:45pm
Marquis Ballroom C

4:00pm

27AF Darn... Cursored 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


Learning Objectives:
1 Internalize the benefits of using SQL in your programs.
2. Correct use of SQL and CURSORS in your RPG Programs
3. Understand error handling in SQL subprocedures and service programs


This is Session ID:170341

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), imPower Technologies
Jim Buck’s career in IT has spanned more than 35 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Tuesday October 16, 2018 4:00pm - 5:00pm
Marquis Ballroom A

5:15pm

28AH Using Watson from RPG
IBM has been making a splash with Watson and cognitive services. Did you know that you can use IBM Watson from your RPG applications? You can, as long as your IBM i can access the Internet. In this session, Scott explains how to integrate Watson's capabilities into your RPG applications.


Learning Objectives:
1. What IBM Watson and Cognitive Computing are, and why they're exciting news.
2. How Watson is made available, which services it provides.
3. How to call Watson from your RPG programs and get back the results.


This is Session ID:170671

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Tuesday October 16, 2018 5:15pm - 6:15pm
Marquis Ballroom C
 
Wednesday, October 17
 

8:00am

31AH 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.


Learning Objectives:
1. Understand the process and various options when setting up the Integrated Web-Service Web Server.
2. Understand how to write subprocedures in service programs that can be used for a web service.
3. Understand how to consume a web-service using technologies like PHP.


This is Session ID:170342

Speakers
avatar for Jim Buck

Jim Buck

Number ONE in IBM i Education! :), imPower Technologies
Jim Buck’s career in IT has spanned more than 35 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM... Read More →


Wednesday October 17, 2018 8:00am - 9:00am
Marquis Ballroom C

9:15am

32AH Getting Started with Consuming Web Services on an IWS Server
Consuming web services is an important skill for today's IBM i Developer. This session will give some examples of how a developer can easily consume a web service installed on an IWS server with a back-end RPG program performing all CRUD(Create/Read/Update/Delete) functionality. Topics covered in this session will include - 1. Downloading and getting started with Bootstrap 2. Coding the call to the web service 3. Understanding the JSON returned from the service. 4. Useful websites for getting started Takeaways - 1. Articulate the process of installing and using Bootstrap 2. Understanding the connection to the IWS server 3. Answers to common problems when working with web services and service programs


This is Session ID:180301

Speakers
avatar for Michelle Lyons

Michelle Lyons

Chief Operating Officer, imPower Technologies
Michelle is an independent IBM i consultant and co-owner of imPower Technologies with Jim Buck. She has been actively involved in the IBM i community – volunteering for COMMON, working on the annual “Women in IT” Event for Wisconsin Midrange Computer Professional Association... Read More →


Wednesday October 17, 2018 9:15am - 10:15am
Marquis Ballroom C

10:30am

33AH Consuming Web Services from RPG with HTTPAPI
Web services have taken the world of IT by storm. This session discusses what a Web Service is and how the free HTTPAPI tool can be used to access (i.e. "consume") them from your RPG programs. It will also show you how to process the resulting JSON or XML document using RPG's DATA-INTO and XML-INTO opcodes.


Learning Objectives:
1. What web services are and how they are used
2. The types of web services
3. How to use RPG and HTTPAPI to consume them 4. Examples


This is Session ID:170315

Speakers
avatar for Scott Klement

Scott Klement

Director, Product Development and Support, Profound Logic Software
Scott Klement is the Director of Product Development and Support at Profound Logic Software, and is well known as both an author and speaker in the IBM i community. Scott is a passionate advocate for RPG on the IBM i platform, and enjoys teaching tips and techniques to other developers... Read More →


Wednesday October 17, 2018 10:30am - 11:30am
Marquis Ballroom C