UIIPA – Our 34th Year!

UIIPA – Our 34th Year!

Utah IBM i Professionals Association

Using Db2 and SQL with Open Source Languages on IBM i

Date: Wednesday, January 16th, 2019

Time: 11:00am – 12:30 pm (Free parking, Raffle, Lunch, & Networking)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]

Topic: Using Db2 and SQL with Open Source Languages on IBM i

Speaker: Alan Seiden, founder of Seiden Group, award-winning speaker, “performance guru of PHP on IBM i.”

Who Should Attend: Developers, Admins, Account managers, support staff, and more – all are welcome

Bio: Alan Seiden founded Seiden Group to help IBM i shops deliver high-performance web and mobile applications using PHP, Python, Node.js, other web technologies, DB2 for i, and IBM i business logic.

With a passion for open source and community, Alan co-developed the popular PHP Toolkit with IBM. He was one of the first Zend Framework certified engineers, charter member of IBM/COMMON’s PHP Advisory Board; and a consultant for IBM’s manual PHP: Zend Core for i5/OS.

An award-winning speaker, Alan has been called “the performance guru of PHP on IBM i.”

He shares his expertise regularly at conferences and user groups such as COMMON, ZendCon, the RPG & DB2 Summit, OMNI, the Northeast Users Group Conference, OCEAN and WMCPA.

In his spare time, Alan plays the trombone and studies and teaches the Feldenkrais Method® of Somatic Education.

Subscribe to Alan’s monthly newsletter Open Thinking: IBM i Strategy & Tips.
Follow Alan on Twitter: @alanseiden and LinkedIn: linkedin.com/in/alanseiden

A Case for Business Preparedness / Why & How to use Node.JS on IBM i

Date: Wednesday, December 12th, 2018
Time:
11:00am – 11:45am – A Case for Business Preparedness (Tony Wilde)
11:45am – 12:30pm – Why & How to use Node.JS on IBM i (Greg Patterson)
12:30pm – Catered Lunch
Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]
 
Lunch Sponsors:
 
Fesche Solutions
 
 
TAOS – Team Assist Outsourcing Solution
 
Presenters:
– Tony Wilde – Business Development Manager and a Corporate Trainer at Utah Disaster Kleenup
– Greg Patterson – Modernization Specialist at Fresche Solutions
Topics:
– A Case for Business Preparedness (Tony Wilde)
– Why & How to use Node.JS on IBM i (Greg Patterson)
Who Should Attend: Developers, Admins, Account managers, support staff, and more – all are welcome.


A Case for Business Preparedness

Bio: Tony has been with Utah Disaster Kleenup since May 2013. He is a Business Development Manager and a Corporate Trainer. His focus is assisting commercial and healthcare clients recover from catastrophic disasters to minor misfortunes.

Prior to UDK, Tony worked for the State of Utah’s, Division of Emergency Management. He taught private sector businesses in planning for disasters using Business Continuity Planning or BCP. He is also a certified trainer of C.O.O.P. or Continuity of Operations Planning.

Along with BCP and C.O.O.P., Tony has trained thousands of private citizens on personal preparedness.

Tony grew up and lives in the Sandy/Draper area of the Salt Lake Valley.

He is a newlywed and the father of seven children, 25 to 16. He is hoping to be a grandpa sometime soon.

Why & How to use Node.JS on IBM i

Bio: Greg Patterson has been in the IT field for 18 years, the last 10 with Fresche Solutions where he is currently a Modernization Specialist.

In addition to business development activities, Greg also coordinates pre-sales technical demonstrations and discussions, performs business analysis, and is sometimes involved at the coding level for specific projects.

Greg has a deep knowledge of Fresche products from his time spent in support as a Senior Technical Support Specialist.

Parsing JSON and XML with RPG

Date: Wednesday, November 14th, 2018
Time: 11:00am – 12:30pm (Free Parking, Raffle, & Lunch)
Location: BMA – 2151 South 3600 West, Salt Lake City, UT 84119 (Park & Enter from East side – rear/side of building)
Presenter: Shihab Aboobacker – Sr. Software Engineer at Dealertrack
Topic: Parsing JSON and XML with RPG
Description:
  • What is JSON and XML and their uses.
  • Explore different methods for parsing and using JSON and XML data in RPG.
  • Demo DATA-INTO, XML-INTO and XML-SAX
Who Should Attend: Developers, Admins, Account managers, support staff, and more – all are welcome.
 
BioShihab is a Sr. Software Engineer at Dealertrack. He has been working on the IBM i and it’s predecessors for over 15 years. He graduated with a Bachelors in Electronics and Communication Engineering and has worked in IT departments of organizations from various industries such as financial services, transportation & hospitality, manufacturing, telecommunications and finally in automotive. He was introduced to programming while studying in middle school with the QBasic programming language and then later studied Turbo C++ and Java in school. It was while working as an intern he was introduced to the AS400 and RPG programming language and that experience helped him land his first job as an RPG developer.

Shihab currently works as an engineer in the DMS-OEM communications team and a major part of his work deals with preparing/sending and receiving/parsing payloads in a variety of formats such as XML, JSON, flat files etc from and to the IBMi. He constantly researches the different options available to perform these functions.
Shihab is married and is a dad to two girls, 7 and 3 years old. He moved to Utah last year from Florida and, although he misses the beaches, he enjoys the Utah outdoors and loves to go hiking and discovering new places.

iNav – Android Navigator for i (Part 1)

Date: Wednesday, October 24th, 2018

Time: 11:00am – 12:30pm (Free Parking, Raffle, & Lunch)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]

Presenter: Haroldo Paulino – Android Software Engineer (iSolved)

Topic: iNav – Navigator for Android (Part 1)

 This project makes heavy use of the IBM JT400 Java api.

* What can be done with connections properties?

* How to use voice commands to manipulate IBM i.

Who Should Attend: Developers of all levels/languages/platforms. Admins, Support Staff, Bosses, Network/Security Engineers, and anyone without a defined business “Mobile Strategy”

Bio:

Haroldo began his career in 1995, at the company he founded, in partnership with his brother and was initially responsible for IT services, along with developing MS-DOS based database applications.

He graduated with a BA in Computer Science in 1999, when his role as a programmer for his own company had grown exponentially. He had already incorporated several different technologies into his daily routine, among those: Pascal, Delphi, Dbase, Interbase, Paradox, MySQL, SQL, Sockets, parallel printer API control, using Assembly for various task like dial-up modem communication, and remote oil rig valve control.Haroldo

He also became a consultant for one of Brazil’s biggest banks, Federal Reserve Bank, where he recruited a specific team to build a major banking system that governed several branches’ daily workload.

He is a researcher by nature; always learning about new tools that can expand his reach and deliver quality results.

His current programming passions are Java, Android and iOS.

Even though his company was moving forward, he wanted to live in the USA. He immigrated in 2003, got married and currently has two children.

He enjoys going on bike rides with his family, swimming laps and building great memories with his loved ones. If you ever see two bikers riding around Layton, it’s probably him and his son.

Haroldo values focus, discipline and fun. Work hard, play hard.

Activation Groups

Date: Thursday, September 27th, 2018

Time: 11:00am – 12:30 pm (Free parking, Raffle, Lunch, & Networking)

Location: Dealertrack – South Jordan campus – 10757 River Front Parkway, South Jordan, UT 84095, 2nd Floor, Superior Peak

Topic: Activation Groups

Speaker: Charles Wilt, Sr. Software Engineer – Dealertrack (Cox Automotive)

Session Abstract:  *NEW, *CALLER, ‘QILE’, and ‘MYACTGRP’…oh my!  It’s not quite October yet, but we’re getting there; so how about a topic that’s scary for too many RPGLE developers…ILE activation groups!  Activation groups are an important feature of ILE and using them properly is a key to getting the most out of ILE development.  Please see the following link for more information:

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzahw/rzahwgrxco.htm

Who Should Attend: This session will appeal to Developers and anyone wanting to learn more about Activation Groups on the IBM i.

Charles Wilt recently relocated to Utah from southwestern Ohio to join Dealertrack, Inc. as a Sr. Software Engineer.   He has a BS in Computer Science and started his programming career in COBOL on Honeywell  DPS 6 systems in 1991.  In 1996, he started working with his first AS/400, a RISC box running v3r6 running an application written in RPGIII; but it didn’t take him long to find out about RPGIV and SQL. Charles has never written a cycle program, though he’s sure he must have maintained one somewhere.   Today, Charles’ expertise includes  fully-free RPG, modular coding, web services using RPG, and advanced SQL .

 

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.

Escape from Venezuela

Date: Wednesday, June 20th, 2018

Time: 11:00am – 12:30pm (Free Parking, Raffle, & Lunch)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]

Presenter: Joshua Holt and the Holt Family

Topic: Escape from Venezuela

Abstract: Joshua will join us along with family members to share his experience in a relaxed, up close and personal setting with our User Group.  Please join us, ask questions, and get behind the news stories and politics.

Who Should Attend: Everyone – Voting for new UIIPA leadership will be limited to “membership holders” only.

Luncheon: Please RSVP with headcounts, this lunch will be catered by Panda Express.

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.

Db2 Web Query for i – from Query/400 modernization to advanced data visualizations – all on IBM i !

Date: Wednesday, May 16th, 2018

Time: 11:00am – 12:30pm (Free Parking, Raffle, & Lunch)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]

Presenter: Doug Mack – Analytics Consultant, Db2 for i, IBM Systems Lab Services

Topic: Db2 Web Query for i – from Query/400 modernization to advanced data visualizations – all on IBM i !

Abstract: With the thirty year anniversary of the “AS/400” being this year, you might ask yourself why you’re still using 30 year old green screen query when IBM has a much more powerful solution, Db2 Web Query, that will blow your green screen socks off. AND….takes advantage of query acceleration technologies in Db2 for i that have been added over time, including the newer SQL Query Engine that processes queries. This session will provide background, introduction, and what’s new information on Db2 Web Query for i.

Who Should Attend: Developers, Admins, Account managers, support staff, and more – all are welcome.

Bio: Doug Mack is a DB2 for i Analytics Consultant in IBM’s Power Systems Lab Services organization, employed by IBM in the United States.

Doug currently leads the Analytics team for the DB2 for i Lab Services team delivering Query/400 modernization, DB2 Web Query, Data Warehouse design, skills transfer, and implementation guidance services worldwide.

Doug is a regular speaker at customer events including COMMON, IBM Technical Conferences and Executive Briefings, and has written many articles and white papers on the attributes of DB2 for i for analytics.

You can follow Doug on Twitter @mckdrmoly or via his blog at db2webqueryi.blogspot.com

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.

 

Live Internet of Things (IoT) demo with the IBM i

Date: Wednesday, April 18th, 2018

Time: 11:00am – 12:30pm (Free Parking, Raffle, & Lunch)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]android-code

Presenter: Haroldo Paulino – Software Engineer (BMA Banking Systems)

Topic: Live Internet of Things (IoT) demonstration with the IBM i

This will be a fun Internet of Things (IoT) presentation with custom hardware and circuits being controlled by a live IBM i system.

A “thing” is any object with embedded electronics that can transfer data over a network — without any human interaction. Examples are wearable devices, environmental sensors, machinery in factories, devices in homes and buildings, or components in a vehicle.

  • What will be covered:
    • Controlling house lights, sprinklers and even Christmas lights with your IBM i.
    • How to interact with various electronic sensors. Temperature, Humidity, Light, Proximity and more.
    • IBM i running a Smart Mirror.
    • Java, SQL, Python and Arduino.

Who Should Attend: Developers of all levels/languages/platforms, Admins, Account managers, support staff, colleagues, bosses and more – all are welcome.

Bio: Haroldo began his career in 1995, at the company he founded, in partnership with his brother and was initially responsible for IT services, along with developing MS-DOS based database applications.

He graduated with a BA in Computer Science in 1999, when his role as a programmer for his own company had grown exponentially. He had already incorporated several different technologies into his daily routine, among those: Pascal, Delphi, Dbase, Interbase, Paradox, MySQL, SQL, Sockets, parallel printer API control, using Assembly for various task like dial-up modem communication, and remote oil rig valve control.Haroldo

He also became a consultant for one of Brazil’s biggest banks, Federal Reserve Bank, where he recruited a specific team to build a major banking system that governed several branches’ daily workload.

He is a researcher by nature; always learning about new tools that can expand his reach and deliver quality results.

His current programming passions are Java, Android and IOS.

Even though his company was moving forward, he wanted to live in the USA. He immigrated in 2003, got married and currently has two children.

He enjoys going on bike rides with his family, swimming laps and building great memories with his loved ones. If you ever see two bikers riding around Layton, it’s probably him and his son.

Haroldo values focus, discipline and fun. Work hard, play hard.

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.

 

SQL for the RPG Developer

Date: Wednesday, March 21st, 2018

Time: 11:00am – 12:30 pm (Free parking, Raffle, Lunch, & Networking)

Location: Dealertrack – South Jordan campus – 10757 River Front Parkway, South Jordan, UT 84095, 2nd Floor, Superior Peak

Topic: SQL for the RPG Developer

Speaker: Charles Wilt, Sr. Software Engineer – Dealertrack (Cox Automotive)

Session Abstract:  This month’s session will focus on SQL for the RPG Developer.

Who Should Attend: This session will appeal to Developers and anyone wanting to learn more about SQL on the IBM i.

Charles Wilt recently relocated to Utah from southwestern Ohio to join Dealertrack, Inc. as a Sr. Software Engineer.   He has a BS in Computer Science and started his programming career in COBOL on Honeywell  DPS 6 systems in 1991.  In 1996, he started working with his first AS/400, a RISC box running v3r6 running an application written in RPGIII; but it didn’t take him long to find out about RPGIV and SQL. Charles has never written a cycle program, though he’s sure he must have maintained one somewhere.   Today, Charles’ expertise includes  fully-free RPG, modular coding, web services using RPG, and advanced SQL .

 

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.

Spectre/Meltdown Vulnerabilities and Remediation

Date: Wednesday, February 21st, 2018

Time: 11:00am – 12:30 pm (Free parking, Raffle, Lunch, & Networking)

Location: ADP Salt Lake City – 2835 Decker Lake Drive, Salt Lake City, UT 84119 [Directions/Parking Info]

Topic: Spectre/Meltdown Vulnerabilities and Remediation

Speaker: Joe Wood, Engineer – ADP, LLC

Session Abstract:  This month’s session will focus on the Spectre and Meltdown Vulnerabilities, what they are, and what can be done to mitigate them on the IBM i.  The presentation will cover Chips/Models affected, Risks, and IBM Stack Review and User experience, Pitfalls and Best Practices.  Those in attendance will receive a copy of the presentation with helpful reference links and system commands.  The information will span entry level single systems to highly virtualized multi-frame environments.

Who Should Attend: This session will appeal to Power System Administrators, System Operators, Network Administrators, Developers.  Anyone concerned with security will benefit.

Joe Wood is currently an Engineer in the Global Enterprise Technology Group @ ADP, LLC where he shares responsibility for the company’s IBM Power Platform which complements a larger group of zSeries Mainframes, Windows servers, and Open System platforms serving 620,000 customers spanning 125 countries with 55,000+ Associates.  Joe has 34 years of experience on the IBM midrange platform serving in capacities from Operator/Admin to top level IT leadership.  His experiences in small, medium, and large businesses (Including consulting) have contributed to his ability to be everything from “hands on jack of all trades” to developing and implementing IT/Business strategic directions.

He has participated in and presented at the U of U IT round table series, a Westminster MBA Knowledge management session, and numerous IFDA (International Foodservice Distribution Association) events around the U.S.  Joe has a passion for process improvement, behavior changing software/technologies, and thoroughly enjoys competing at any level and activity. He has served in various volunteer capacities including School Community Council chairperson, UIIPA User Group leadership, and IFDA’s IT Committee Chair. He regularly joins networking and share groups when and where relevant.

We thank Joe Wood for his expertise in this area and look forward to this session !

 

Special thanks to Maxava (Business Continuity, Disaster Recovery, & High Availability Software for the IBM i) for their generous contributions and support of the UIIPA membership.