The New England Midrange Users Group








Contact an Officer

 Download Annual    Invoice

Home Page



Next Meeting - Wednesday, November 15, 2017 - IBM i SQL Stored Procedures and Application Modernization


The New England Mid-Range Users Group is organized as a resource for users of IBM System i, i Series and AS/400 systems. If you were looking for the New England M User's Group (MUMPS) goto

PLEASE NOTE - Different location this month!

Date: Wednesday, November 15,  2017

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

Place: New Location: Red Stone Grill, 120 Chestnut Street, North Attleboro, MA 02760  register
Topic: IBM i SQL Stored Procedures and Application Modernization
Speaker: John Valance
Dinner: Chicken Saltimbocca - Chicken breast sautéed in a white wine demi sauce and topped with sage, prosciutto and mozzarella, served with mashed and vegetable, or Beef Kabobs - Grilled marinated flap meat skewered with peppers, onions and mushrooms, served with rice and vegetable, or Linguine Frutti de Mare - Fresh seafood of littlenecks, salmon, haddock, shrimp, calamari in a spicy plum tomato basil sauce, or 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, and pay at the door

R.S.V.P. to Rasa Pizzi.  Register on the web, or e-mail
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

NOTE:  Annual membership payment is due for the 2017-2018 season.  If your company has not registered yet, download the annual invoice for membership from the NEMUG website  Bring the membership registration with check (payable to NEMUG) to the meeting to receive member rates.

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 ( John can be reached at

NEMUG Officers

President Dawn Dawson, The Moore Company (401) 315-6351
Vice President Chip DiFolco, Callico (774) 227-7373
Secretary Rasa Pizzi, Franklin Sports, Inc. (781) 573-2443, (508) 944-1545
Treasurer Eileen Newell, FGX International (401) 719-2337
Webmaster Jerry Perreault (401) 949-2613
NE Conference Liaison Chip DiFolco, Callico (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 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/2017)


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

May 16, 2018


June 20, 2018

TBD - Donna Westmoreland (Midrange Dynamics)



click here--> Dick Evans says Thank You! <---click here


Click for NEMUG Apparel



The next meeting
November 15, 2017


Manage your subscription to NEMUG emails


Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Subscribe
For Email Marketing you can trust

The Maxava iFoundation, established by Maxava, to support non-profit IBM i user groups, has awarded a grant to NEMUG.  We are proud to be recognized by the Foundation, and to have been selected for this award.  We look forward to a lasting relationship with them.

Click on either of the links to learn more about Maxava, and the Maxava iFoundation.


Click to see a 1968 midrange computer!




Copyright 2011-2012 New England Midrange Users Group

Site created and maintained by Jerry Perreault  -- Last updated November 04, 2017 -- Best Viewed at 800x600

Top of Form