New England Midrange Users Group

Meeting Announcement


Wednesday, November 15, 2017


Sign In 5:15 p.m.; Speaker 6:00-7:15 p.m., Dinner to Follow


New Location: Red Stone Grill, 120 Chestnut Street, North Attleboro, MA 02760


IBM i SQL Stored Procedures and Application Modernization


John Valance


Chicken Saltimbocca – Chicken breast sauté in a white wine demi sauce and topped with sage, pros and mozzarella, served with mashed and vegetable

Beef Kabobs – Grilled marinated flap meat skewered with peppers, onions and mushrooms, served with rice and vegetable

Linguine Frutti de Mare – Fresh seafood of littlenecks, salmon, haddock, shrimp, calamari in a spicy plum tomato basil sauce

Vegan or Vegetarian – available on request

Cost: NEMUG Members $30, Guests $40, Students $10. Make check payable to: NEMUG. Mail to: NEMUG, c/o Eileen Newell, 455 Smith Street, N. Attleboro, MA 02760 or register on the NEMUG web site, www.nemug.com, and pay at the door.

R.S.V.P. to Rasa Pizzi. Register on the web, www.nemug.com, or e-mail rpizzi@franklinsports.com.

We must receive your reply no later than Friday, November 10, 2017.

** No shows will be billed, unless cancellation is received by Tuesday, November 14, 2017. **

IBM i SQL Stored Procedures and Application Modernization

Among the many modernization technologies available on IBM i, SQL is perhaps the one best known by RPG developers. This session won't focus on how to write SQL statements, but rather how to write scripts that combine SQL statements together into procedures that encapsulate database access and

core business logic for use in a myriad of modern applications. We'll discuss how stored procedures fit

into a modernization strategy, and why they are such a good fit for RPG programmers who want to

participate in modernization projects. They're also a great fit for anyone new to IBM I who needs access

to its database for applications in PHP, Java, Crystal Reports, IBM Web Query, Excel, Web Services, conversion projects, etc.

SQL is often embedded in other languages, such as RPG, PHP, Java, etc. But IBM provides the SQL

Procedure Language (SQL/PL), which can be used to code complex or multiple SQL statements into

procedures that can form the backbone of a service oriented architecture. These procedures can be

called from any programming language. This can simplify the database access code in PHP, Java, and

other host languages, while taking full advantage of DB2-specific SQL features.

Come and learn about the many features and benefits of SQL stored procedures, how to code them, and

how to use them in your modernization strategy.

John Valance has worked on the IBM midrange platform since 1983 and on web development since

1998. With a strong background in both RPG and web development, John enjoys sharing his knowledge

with the IBM midrange community. He has extensive programming experience in RPG, Java, PHP, and

JavaScript, and he enjoys explaining new programming concepts to RPG programmers. John is a

frequent presenter at user groups across North America. John is the founder and CTO of Division 1

Systems, a software services firm based in Burlington, Vermont USA (www.div1sys.com). John can be

reached at johnv@div1sys.com.

NEMUG Officers


Dawn Dawson,
The Moore Company

(401) 315-6351


Vice President  

Chip DiFolco,


(774) 227-7373



Rasa Pizzi

Franklin Sports, Inc.  

(781) 573-2443,

(508) 944-1545



Eileen Newell,
FGX International

(401) 719-2337  



Jerry Perreault

(401) 949-2613


NE Conference Liaison  

Chip DiFolco,


(774) 227-7373


Message from the President

Thank you to Christopher Burns from GEMKO Information Group out of Buffalo, NY for travelling to speak to NEMUG about his Open Source adventures using RPTMOD and INUENDO.  It was an interesting session especially the part about going back in time - that would be a useful tool on most days!

For November we have John Valance, Founder and CTO of Division 1 Systems to speak to us about SQL Stored Procedures and the role they play in Application Modernization. John is on the COMMON Board of Directors and a frequent speaker nationwide.  He works with Web/Mobile applications for the IBM i as well as design, project management, coding, training and consulting on the IBM i and is a Zend Certified Engineer.

Dawn Dawson, President NEMUG

Attend NEUGC for FREE!!!
Do you want to attend the Northeast User Groups Conference in Framingham, MA for FREE? All you need to do is attend NEMUG meetings between September 2017 and March 2018. Those in attendance at the meetings will be entered into a drawing for a free registration for the April 23-25, 2018 conference.  Attending more than one of our NEMUG meetings? Get one entry for each meeting you attend. At one of our meetings in early 2018, we will draw the winner.  (Winner is responsible for their own lodging, transportation, and other expenses)

E-mail Notification

If you are not on our e-mail list, go to the web site at www.nemug.com and click on the "Subscribe" button to be added to the list.

Welcome to the following New and Renewing Member Companies

(as of 10/18/17)

Aurora Technologies


FGX International

Franklin Sports, Inc.

JH Lynch & Sons, Inc.

Mestek, Inc.

The Moore Company

NATCO Products Corp.

Thank you for your support of NEMUG!

If your company has not registered yet, go to the website to download the annual invoice for membership (on left side of the home page). Bring a check (payable to NEMUG) and the form with you to get the member prices at the meeting.

(Schedule is subject to change)

September 27, 2017

Beyond Rational Data - NOSQL Data - Jim Mason

October 18, 2017

Open Source Tools - Christopher Burns

November 15, 2017

IBM i SQL Stored Procedures and Application Modernization - John Valance

December, 2017

No meeting - Enjoy your holidays

January 17, 2018

Putting The Pedal to the Metal with RDi - Charlie Guarino

February 21, 2018

What you need to know when upgrading IBMi to 7.3 - Pete Massiello

March 21, 2018


April 23 - 25, 2018

NE User Groups Conference, Framingham MA www.neugc.org

May 16, 2018


June 20, 2018

TBD - Donna Westmoreland (Midrange Dynamics)