NHMUG Welcomes Charlie Guarino on Thursday November 21st at the Backyard Brewery in Manchester NH
Interaction between internal and external systems is becoming more the norm. Learn about the use of web services as a way to accomplish this interaction utilizing both XML and JSON.
The PDFs from Charlie's session have been added. Click on the title of the session for that presentation.
The “Best Stuff” of Advanced RDi
Once you have a solid basic understanding of RDi you will want to attend this advanced session that demonstrates many of the finer points of application development. Here is where you can truly customize RDi to watch your development time shrink and performance soar.
Introduction to Processing XML in RPG and SQL Too!
XML has quickly become a standard method of encoding data. It can be used for full document transmittals or data provided via a web service.The extraction of this data into useable information is called parsing. RPG provides two different methods for parsing.
This session goes step by step through the entire process of receiving an XML document to successfully parsing it to a database file. The XMLINTO and XML-SAX statements will be reviewed. The challenges and requirements of both statements will be discussed.
At the end of this session, you will be able to identify which parsing method works best for your particular situation. Included with this session are program listings that you can take back and put to use immediately. Updates to this session include i7.1 TR6’s exciting SQL XML processing.
Learning Objectives:
- Gain a basic understanding of XML syntax
- Learn how XML parsing has been implemented into RPG
- See live examples of the XML parsers at work
i Can Serve You – Providing Web Services From Your IBM i
Now that you’ve been consuming web services, get ready to turn the tables and become the web service provider. Using IBM’s Integrated Web Services server for ILE you too can launch programs to access your database and provide your system’s information to external users such as web developers.
We will go step by step through the process of creating a program to receive a parameter and return database values. Next we will implement this program on to the built-in web services server and demonstrate how to test and deploy it using IBM’s graphical Web Administration tool. Since the tool is wizard-driven deploying web provider side web services has never been easier!
XML and JSON REST Web Services for Everyday RPG and SQL Consumption
A web service extends your applications in a way that no traditional programming can. They allow you to get real time information for almost any requirement.
We’ll discuss what web services are, how they function and how you can begin using them on your own system. Get step-by-step instructions on the entire Web service process from receiving an XML or JSON document to successfully parsing its information to a display or database file. See working RPG code of an XML parsing program and watch how we consume a RESTful web service.
Updates include i7.1 SQL enhancements which make consuming web services a snap. This session includes source code to get started using dynamic Web services today!
Biography
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.
He is a member of COMMON’s Speaker Excellence Hall of Fame and a proud recipient of the Al Barsa Memorial Scholarship Award. Additionally, he participates on COMMON’s Strategic Education Team. Other professional endeavors have included the roles of President and monthly Q&A host of the Long Island System User’s Group LISUG (www.lisug.org)
Today, along with the team at Central Park Data Systems, he is serving individuals and companies on a worldwide basis though his consulting work and award-winning speaking engagements.
Charles is a true people person and can often be found at conferences sharing his expertise on RDi and other IBM i topics.
Email -
LinkedIn - http://www.linkedin.com/in/guarinocharles
Twitter - @charlieguarino
NHMUG hosted the first sessions of the 2019/2020 season on Thursday September 26th at the Backyard Brewery in Manchester NH
Extract, Transform and Load your data with Kyle Rainville (@ 2 hours)
Join Kyle Rainville as he discusses the ETL, (Extract, Transform and Load), process. He will share some available tools and if like a lot of businesses on a low budget how you can do the same thing with DDM files and views in order to segregate your reporting data from your production data. Lastly he’ll discuss how to consume that data using tools like Neo4J and PHP.
Presentation PDFs:
ETL-Open-Source-and-Leveraging-Data.pdf
Supporting BI and Reporting projects in Db2 with Rick Flagler (@ 2 hours)
Rick Flagler will review Db2 capabilities that we have to massage data, create reports and support BI. He’ll look at various Db2/SQL techniques, with advantages of each and with an eye to performance impacts. On the BI front, a consideration of many vendors out there with a focus on IBM’s Db2 Web Query for i as a presentation layer. Some differentiating the Express and Standard offerings may be covered.
Presentation PDFs:
BI Round Table with Dawn May (@ 1 hour)
Dawn May will be leading a round table discussion on how members are currently using BI and what were the obstacles, opportunities and requirements. Bring your ideas and questions!
Biographies
Kyle Rainville graduated from Plymouth State University with a Bachelor’s degree in Information Technology as Magna Cum Laude in December of 2016. Kyle started working at Littleton Coin Company as a Programmer & Network Analyst in June of 2016. Kyle is passionate about open-source technology and Linux and learning.
Rick Flagler is a consultant, trainer and mentor, focusing on DB2 performance, business metric development and DB2 Web Query. Rick has held IT management positions with The Timken Company and MPB Corporation, leading software development and installing ERP systems from SAP, Oracle and INFOR. Starting with the System/38, Rick is a long-time and enthusiastic supporter of IBM i on the POWER platform. Rick guided MPB Corporation through their Y2K project, achieving on-time/under budget success. He's an experienced project manager, skilled in database management and user interface design. He specializes in transforming data to knowledge using business metrics and database tools. He is president/owner of Rick Flagler IT Consulting.
Dawn May is a leading authority on IBM i performance management, work management, systems management, and general system diagnostics. She has in-depth knowledge of the IBM i operating system developed through her distinguished career with IBM. A former IBMer, Dawn is now an independent consultant, assisting companies with system performance reviews and recommendations. She also teaches clients on the latest IBM i tools to enable them to get the most out of their IBM i systems. Dawn is the author of the "i Can" blog published by IBM Systems Magazine and a frequent speaker at local user group meetings and IBM i conferences around the world.
31st Annual New Hampshire / Vermont IBM i User Group Meeting
Thursday, June 20 2019 - Fireside Inn, West Lebanon NH
We are excited that Steve Fier and Ted Holt presented this year. For those of you that have had the pleasure to hear them in the past you know the value they bring to the table from both the hardware and software perspectives
This event was free to IBM i professionals, and sponsored by NHMUG and VTMUG
IBM Announcements - Steve Fier, IBM
Steve talked about the new I OS version 7.4 and provided an overview of IBM i 7.3 TR6.
Highlights included:
- Security Enhancements
- DB2 for i
- Continuous Availability – DB2 Mirror
- Access Client Enhancements
About Steve
Steve Fier has been with IBM over 30 years, initially starting as a systems engineer, and then becoming a senior marketing specialist. His current role is POWER Platform Leader for the Northeast, responsible for former System i and System p products. Steve's areas of expertise include application development, DB2 for i, Windows Integration and Server Consolidation.
Refactoring RPG: What, Why and How - Ted Holt - Profound Logic Software
Download Refactoring-RPG.pptx
Refactoring is rewriting source code in such a way that the new code behaves as the current code does, but is easier to read, understand, modify, enhance and debug. Refactored code takes advantage of features that were not available, or were ignored, when the code was written. This presentation, which is geared toward the RPG programmer, is given by Ted Holt, who has been writing RPG programs since 1982 and has programmed in RPG II and every version since then. Ted explains what refactoring is and is not, why you should refactor, when you should not refactor, and how to refactor RPG. If you have old RPG code in your shop (and who doesn't?), this presentation is for you.
Say Yes to Change - Ted Holt
Download Say-Yes-to-Change.pptx
Nobody likes to tell the bigwigs that changing the software to accommodate a change in business requirements is impractical or impossible. Whereas we need to say yes, we often say no because we lack time and resources to modify the software systems we support. Abstraction, the hiding of unnecessary detail, makes software more flexible and open to change, and makes programmers more productive. In this session, Ted Holt shows how to use such common techniques as SQL views, logical files, and service programs to build software that can respond to changing business requirements. Aren’t you tired of saying no?
21st-Century CL - Ted Holt
Download 21st-centry-CL.pptx
IBM i Control Language (CL) has long been used as a language for both operations and job control. In recent releases of IBM i (V5R3 thru 7.2) IBM has delivered many long hoped for and long requested enhancements to CL for both environments.
Enhancements include new commands as well as new extensions to existing commands. What are these new features and functions? How can they be used? What's the very latest that CL has to offer? This session will answer those questions and more.
About Ted
Ted Holt is a Senior Software Developer with Profound Logic Software, a provider of modernization solutions for the IBM i world. He has worked within the information technology industry since 1981, primarily with IBM midrange computers. His industry experience includes the fields of manufacturing, healthcare, education, retail, and wholesale. He holds a master's degree in computer science from the University of Southern Mississippi and has taught in community colleges, universities, and vocational/technical schools.
Ted is the author of several books on programming topics, including OpenQuery File Magic!, Complete CL, Power CL, Qshell for iSeries and the MC Press Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400. He is a regular speaker for the RPG and DB2 Summit and serves as technical editor and writer for Four Hundred Guru, a technical newsletter published by itjungle.com.
On Thursday March 21st, 2019 Pete Massiello brought us up to speed on things related to the care of your IBM i
Meeting Handouts:
Putting the pieces together
Cool things in Navigator for IBM i
Differences in classic GUI HMC and Enhanced GUI
Tips and Tircks to improve performance
HMC, IBM I, FSP, & Firmware: Putting All the Pieces Together
Come to this session and dissect all the new components and concepts involved with partitioning your IBM Power Systems. Learn how all the pieces connect to each other, what you need to do to set them up, and how to manage and upgrade them. Get a handle on the various components of the Hardware Management Console (HMC), the Flexible Service Processor (FSP), and the Advanced Systems Management Interface (ASMI). Find out about the firmware in your machine, and how to make the required updates to it in an LPAR environment or on a standalone machine. Get tips for upgrading and setting up communications between the HMC and FSP as well as insight on where the ASMI fits in. Leave this session with up-to-date knowledge on these important hardware features of IBM Power Systems & IBM i.
Cool Things in Navigator to be a Rockstar System Administrator
IBM Navigator for i is a powerful new tool to better manage your i environment. Get expert advice for installation and set up to make sure you get this powerful tool up and running at peak efficiency. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Learn ways to protect your system from intrusions, as well as close security holes such as FTP. See how this tool can help you select and install Logical files on your system to improve performance. Learn about the enhancements to this valuable tool in the release of version 7.3, while we see how this tool provides tips and techniques for better and more easily managing your IBM i.
Moving from HMC Classic GUI to the New Enhanced GUI
The new Enhanced GUI is really nice, but if you haven't used it, it is very different from the classic GUI. Basically, you can't find anything, and things work and behave differently. Come to this session to learn where the functions you were used to using, where they are now.
Tips and Tricks to Improve System Performance and Save Disk Space
What can you do to stop the rampant growth of data that’s eating up disk space? How do you improve system performance? Come to this session to find out how to make the most out of your existing configuration by leveraging the many optimization and cleanup techniques that are a part of i5/OS, including reorganization of physical files, sharing of access paths, and using the DISKTASK command. Pinpoint how to reduce your disk I/O by reorganizing files and clean up your system using the Retrieve Disk Information (RTVDSKINF) and Retrieve Directory Information (RTVDIRINF) commands. Learn how sharing access paths can reduce disk utilization and memory faulting. Know your options for reorganizing your files while your users continue to access them.
Biography
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions throughout his career and is currently the President of iTech Solutions Group, an IBM Premier Business Partner delivering solutions and services to IBM i shops throughout the United States. He is a member of IBM's certification test writing team and an IBM Certified Systems Expert with certifications in iSeries Design, Administration, Virtualization, Implementation, LPAR, and HMC Management.
Pete has a BS in Computer Science from Hofstra University and an MBA from the University of New Haven. He was President of COMMON from 2010 to 2012, and is now Immediate Past President, a COMMON Hall of Fame speaker, and a frequent speaker at user groups all over the world. In 2011, IBM established the Champions award for Power Systems; Pete was one of the first recipients.