Omni Banner

Create IBM i PHP Dashboards
with RPG, DB2, & Google Charts
Greg Cannella

Tuesday February 16th 2016

Greg Canella

Casey's Restaurant and Bar
415 E. North Avenue (IL-64), East of I-355
Lombard IL

5:00 Registration
6:00 Dinner and Business Meeting
7:00 Presentation

meals | register | cancel | directions

Greg Cannella will present an Omni member Case Study on how to create IBM i dashboards in PHP using RPG and DB2. He'll also show how to integrate Google Charts for graphical portrayals of DB2 for i data from line of business systems of record. Greg will explain some of the many modern IBM i coding techniques that have been used to create these dashboards and provide sample code which can be used to learn some of the newer RPG syntax. Specific coding techniques that Greg will address include:

   . Using SQL in PHP to access DB2 for i data
   . Creating and using SQL functions
   . Using RPG to power a PHP application
   . Why to use SQL rather than the Toolkit
   . Easily building HTML in RPG
   . Using the SQL descriptor area in RPG to learn about a table layout
   . Using the SQL describe command
   . How to create charts using Google charts
   . How to make a Google chart show up on a dashboard

At the end of the session, you will be able to download the sample code, modify it to suit your needs, and Create IBM i PHP Dashboards using RPG, DB2, & Google Charts.

Greg Cannella

Greg Cannella is Director of MIS for Magid Glove and Safety Manufacturing in Romeoville. In this role he manages development and support of all applications including, manufacturing, distribution, logistics, web site and finance applications. He is also responsible for the new software selection process, sets standards, and develops the company wide IT strategic plan.

Dinner Options
Food and Drink are ala carte from

February Dinner Meeting Registration
Please make your reservations by Monday February 15th, 2016.

To register, please do these 2 things...
1) Please submit your information using the form below to express your preferences.
2) Please pay for your registration on The Omni User Store by clicking the store link.
Thanks in advance!

First name:
Last name:
Address 1:
cc billing address
Address 2:

Registration Options:

Please choose options and click Submit Information, and then please pay for your member or non-member dinner meeting on The Omni User Store at the link below the Submit Information button. 2016 Omni Memberships will be verified at the check-in table.
$15 Members
$40 Non-Member

LUG Affiliation:
Southwest Michigan
Gateway/400 Group

To register, please do these 2 things...
1) Please submit your information by clicking the "Submit Information" button below.
2) Please pay for your registration on The Omni User Store by clicking the store link.
Thanks in advance!

Please click the button below to submit your information...

And, please pay for your registration on The Omni User Store

Please invite your friends and associates to join you at the Omni Dinner Meeting. Send them a message to tell them you'll be attending for education, networking, and so much more. For some, it might be a great reason to reconnect with a phone call. Omni appreciates everything you do to spread the word about your best value in IBM i on Power Systems education!
Dinner Meeting Cancellation Policy
Full credit will be issued for cancellations made before 9:00 am Monday February 15th, 2016.
After 9:00 am Monday February 15th, 2016, cancellation credit depends on meeting attendance.
All cancellations must be made by using the web cancellation feature below (the preferred method) or, if you must, by calling (630) 953-6312 and leaving the name(s) of those unable to attend.


Dinner Meeting Directions

The event will be held at Casey's Restaurant and Bar at 415 E. North Avenue (IL-64), East of I-355 in Lombard, IL

Casey's Restaurant and Bar in Lombard is located on the South side of North Avenue (IL-64) east of I-355.

Click here for a map!

For more information
email questions to Jerome Hughes or leave a message on the OMNI line at (630) 953-6312

events | membership | by-laws | board | links | downloads | home

2021 Midwest Road, Suite 200 Oak Brook IL 60523

opinions craved!
email webmaster

2002-2016 The Omni User