The New England Midrange Users Group






Main Menu


Speaker Info




Speaker Handouts

Contact an Officer

 Download Annual    Invoice

Home Page



Next Meeting - BD2 for i - SQL Routines(Triggers, Functions and Procedures


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, April 20, 2016

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

Place: Ambrosia Tavern, 116 Elm St, North Attleboro, MA 02760
Topic: DB2 for i - SQL Routines (Triggers, Functions and Procedures)
Speaker: Tom McKinley, IBM
Dinner: Salmon, served with potato and vegetable; or Chili Chicken, crispy chicken in sweet chili sauce with onions, peppers, scallions and black pepper; or Sirloin Tips served with mushrooms, onions, baked potato and vegetables; or Pasta Primavera, sauteed seasonal vegetables tossed in a lemon basil, lemon, garlic vinaigrette with penne(Vegetarian).  Also included are appetizers, salad, dessert, and coffee/tea.

Cost:  NEMUG Members $30, Guests $40, Students $10.  Make check payable to: NEMUG.  Mail to Aurora Technologies, C/O NEMUG, 5 Old Nasonville Road, Harrisville, RI 02830 or register on the NEMUG web site,  and pay at the door.

R.S.V.P. to Aurora Technologies.  Register on the web,, or e-mail   We must receive your reply no later than Friday, April 15, 2016.  **No shows will be billed, unless cancellation is received by Tuesday,  April 19, 2016.



DB2 for i - SQL Routines (Triggers, Functions and Procedures)


SQL is much more than a query language.  This session introduces you to the three basic types of SQL programs:  Triggers, Functions, and Procedures. Learn how to let the DB do more work on your behalf.  Learn how to add logic to your DB objects using SQL triggers, centralize logic using SQL functions, access most any kind of data via User Defined Table functions, and learn the basics of SQL stored procedures.

Tom McKinley is an IBM Lab Services Consultant working on DB2 for IBM i. His main focus is complex query performance associated with Business Intelligence running on Very Large Data Bases. He worked as a developer or performance analyst in the DB area from 1986 until 2006. Some of his Major pieces of work include the Symmetric Multiple processing capabilities of DB2 for IBM i as well as Large Object Data types. In addition he was on the original team that designed and built the SQL Query Engine. Prior to Database he worked on Licensed Internal Code for System 34 and System 36. Tom is a frequent speaker at IBM and i user group conferences


Message from the Secretary


Unfortunately we had to once again cancel last month’s meeting at the last minute. We apologize for having to do that, but the speaker’s plane arrangements went awry at the last minute and he was not able to make it here from Rochester. We learned a bit about DR (Disaster Recovery) having to cancel at the last minute and will now add e-mails to our Meeting Registration list to make it easier to contact everyone on short notice.

For this month we have been able to book Tom McKinley from the IBM i Development Lab in Rochester, MN. Tom was the person who we had originally asked to talk on this topic, but he was not available for our March date so we are very happy that he is available for us in April. Tom will teach us more about SQL Triggers, Functions and Procedures. Learn how to add logic to your DB objects using SQL triggers, centralize logic using SQL functions, access most any kind of data via User Defined Table functions, and learn the basics of SQL stored procedures. Learn how to get more out of your IBM I by using this powerful tool.

Faith Lamprey, NEMUG Secretary

Free Registration to the NE User Groups Conference, April 11-April 13!

Even though we only had the sheets turned in ar our January meeting to pick from, we did our duty and picked not one, but TWO people to attend the Conference compliments of NEMUG.  The happy winners were Francis (Chico) Kuhn from Intellichief and Dawn Dawson from The Moore Company.  Congratulations to them both and we are sure you will enjoy the Conference.


E-mail Notification

 Many of you receive two newsletters—one through e-mail and the other through snail mail.  In an attempt to reduce our mailing costs, we are asking you to notify us if the e-mail one is sufficient (  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.


Many Thanks to these Member Companies for Supporting NEMUG this Year!

A&H Worldwide
Aurora Technologies
Cape Cod Bay Systems
FGX International
Hart Engineering
iTech Solutions
Jerry Perreault
JH Lynch & Sons
The Moore Company  

NEMUG Officers

President, Dick Ferrara, NATCO
Vice President, Dawn Dawson, The Moore Company
Treasurer, Eileen Newell, FGX International
Secretary, Faith Lamprey, Aurora Technologies

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


Check out the new BLOG page with comments from our members



Click for NEMUG Apparel



The next meeting
April 20, 2016

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 April 02, 2016 -- Best Viewed at 800x600

Top of Form