This year NEUGC is excited to offer you a choice of one of three great Monday sessions on SQL, PHP, and Web Services for only $50.00 when included with your regular conference registration!
Note to conference attendees: Due to unforeseen circumstances, Scott Klement cannot present the Monday Session "Web Services for RPGers" this year, so we are offering a similar Deep Dive on this topic by Charles Guarino. We apologize for any inconvenience, and we look forward to a Scott Klement Deep Dive at NEUGC 2014!
Seminar: Put "Web Services" to Work on IBM i
Presenter: Charles Guarino
With the proliferation of web services, it is vital for developers to understand what they are and how to capitalize on their benefits in their own shops. Using a web service extends your applications by providing access to real-time information. For example, how could an in-house application ever have the current value of a particular stock or the current exchange rate between two currencies without them? Charles Guarino explains how to put Web Services to work in this three-part presentation:
Part 1: RESTful Web Services for Everyday RPG Consumption
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 document to successfully parsing its information to a display or database file. See working RPG code of an XML parsing programs in RDP debug mode and watch how we consume and parse a RESTful web service. This presentation includes source code to get started using dynamic Web services today!
Part 2: Raising the Bar: A Jumpstart to Using SOAP Web Services in RPG
The Internet abounds with available services using Simple Object Access Protocol (SOAP). The process of consuming these services from your programs is a bit tricky, that is until you use one of IBM's latest tools WSDL2RPG, which is a component of Integrated Web Services (IWS). This tool does the heavy lifting for you and sets up an entire environment with a callable RPG service program. And the best part is this V5R4 and above tool is free.
Charles will teach you to work with the tool and review the process of testing and consuming a SOAP web service and displaying its information in a working RPG display program. After attending this presentation you'll be able to create code that will consume a SOAP web service. Here is a great place to start your learning: http://www03.ibm.com/systems/i/software/iws/documentation.html. Part 3: IBM i Here to Serve You!Now that you've been consuming web services directly, 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 user 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.
With an IT career spanning more than 25 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been founder and president of Central Park Data Systems, Inc., a Long Island-based IBM midrange consulting company. He has published several technical and strategic articles for the IT community and is a regular speaker at user groups and technical conferences.
Seminar: Using SQL to Access Data: Go Deeper and Broader with Data-Centric Concepts
Presenter: Linda Swan, IBM Rochester
One of the most popular subjects at NEUGC is the use of Structured Query Language to modernize your existing IBM i applications and develop fast, flexible new applications.
In this session we will cover the concepts of set-at-a-time programming with SQL, including best practices for scalability and performance. We will explore topics such as proper data-centric design, data modeling, some advanced SQL features, and functions. In addition, we will touch on database modernization by moving from DDS to SQL while minimizing or eliminating impacts to existing programs.
Linda Swan is a senior software engineer at IBM in Rochester, Minnesota working on the SQL Query Engine optimizer with a focus on SQL performance tuning and analysis. Linda has written numerous articles about SQL topics and presented at COMMON.
Workshop: PHP for IBM i
Presenters: Mike Pavlak, Solutions Consultant, Zend Technologies and John Valance, Independent Consultant
This is a four-hour Deep Dive where the students bring their own laptop computers and connect to an IBM i LPAR running PHP in the cloud. This session was oversubscribed in 2012 so it has been updated and we are offering it again.
Mike Pavlak is a Solutions Consultant for Zend Technologies. He has developed applications using RPG, CL and PHP, and he can show you how to extend your RPG skills with PHP and the web.
The workshop includes presentations with corresponding lab sections covering the basics of PHP through RPG program calls and database access using DB2 and MySQL. Students will gain an understanding of how the popular PHP programming language works with IBM i, and will leave the workshop with a trial version of the Zend Studio integrated development environment installed on their PCs.
John Valance is an independent technical consultant specializing in database and web application development on the IBM i platform. He is also a trainer for Zend Technologies, teaching PHP foundations for IBM i programmers.