The New England Midrange Users Group








Contact an Officer

 Download Annual    Invoice

Home Page



Next Meeting - Wednesday, September 9, 2020, Presentation by Jim Mason - SQL and Data Management Concepts


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


Date:  Wednesday September 9, 2020

Sign In 5:30 p.m.; Speaker 6:00 - 7:15 p.m., 

Place:  Virtual Meeting, To be held on-line via GoTo Meeting


 SQL and Data Management Concepts



Jim Mason - Sky Web Team


Bring Your Own Dinner

Cost:  No Charge! 

Please let us know if you plan to attend this Webinar no later than Tuesday, September 8, 2020



SQL and Data Management Concepts


SQL and good Data Management are key to every organization's success.
Everyone knows having the right data with the right quality is always important.
This session covers a lot of ground at a high level, quickly on SQL and data management concepts:

1.        Databases and data sources ( SQL, NoSQL etc )

2.        Application access to Data ( Java, RPG, more )

3.        SQL basics

4.        SQL functions

5.        SQL sub queries and pipelines

6.        SQL filter, map, reduce queries

7.        SQL Stored procedures 

8.        External Stored procedures 

9.        Java example of SQL event streams for real-time, automation

10.      Simple example of a Java Lambda expression 

11.      Simple example of an AWS Serverless function

12.      A few simple examples of Java data analytics services 

13.      Logical diagram of a Cloud data analytics solution from data source, transformation, map-reduce and visualization

14.      Some options for frameworks and tools to use for data management 


Speaker Bio:

Jim helps clients turn technologies ( data, services, blockchain, analytics ) into improved operations results, infrastructure, trust, compliance, performance, lower costs, lower risks.
Jim’s background includes:
• Blockchain Practice leader at Sky Web Team
• DMX Foundry Director led cloud analytics, Hyperledger blockchain
• Work on the Hyperledger Fabric Documentation Team
• MOBI Core team for Vehicle Identity standards
• Data services, data warehouse architect
• Director of Infrastructure & Architecture at Fidelity
• Over 100 presentations at COMMON and articles


NEMUG Officers:


Dawn Dawson,
The Moore Company

(401) 315-6351

Vice President  

Chip DiFolco,


(774) 227-7373


Rick Marcotte

iTech Solutions  

(508) 243-3508


Eileen Newell,
FGX International

(401) 719-2337


Rick Marcotte

iTech Solutions

(508) 243-3508

NE Conference Liaison  

Chip DiFolco,


(774) 227-7373

President's Message:

NEMUG would like to thank two great speakers, Dan and Aaron Magid, from Eradani who took time on July 29th to speak to us about the fundamentals of Java Script Programming for RPG Developers.  Eradani ( is a new company in the IBM world located in Berkeley, CA.

 Please join us again on September 9th for another NEMUG Virtual Meeting.  This month we have a great speaker, Jim Mason, Senior Architect at Sky Web Team, joining us to talk to NEMUG about "everything" SQL.  Join us at 5:30 pm for networking - the Speaker will start at 6pm.

Dawn Dawson

NEMUG President


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 9/1/2020)

FGX International

Callico Distributors

J.H. Lynch & Sons

The Moore Company


iTech Solutions

Franklin Sports



If your company has not renewed their NEMUG Membership as of August 2019, 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.

Thank you for your support of NEMUG!




The next meeting
Wednesday, September 9, 2020 -

Register for next meeting:  Click to register


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 Rick Marcotte  -- Last updated September 02, 2020 -- Best Viewed at 800x600

Top of Form