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
||Wednesday, April 20, 2016
Sign In 5:15 p.m. Speaker 6:00-7:15 p.m. Dinner to Follow
||DB2 for i - SQL Routines
(Triggers, Functions and Procedures)
||Tom McKinley, IBM
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, wwwnemug.com
and pay at the door.
R.S.V.P. to Aurora Technologies. Register on the web,
www.nemug.com, 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
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.
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
(email@example.com). 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.
Many Thanks to these Member Companies
for Supporting NEMUG this Year!
Cape Cod Bay Systems
JH Lynch & Sons
The Moore Company
President, Dick Ferrara, NATCO
Vice President, Dawn Dawson, The Moore Company
Treasurer, Eileen Newell, FGX International
Secretary, Faith Lamprey, Aurora Technologies
Evans says Thank You!
Check out the new
BLOG page with comments from