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, May 17, 2017
Sign in 5:15PM; Speaker 6:00-7:15PM; Dinner to follow
||SQL Writing Tips and Techniques
Chicken Parmesan; or Angus Steak Tips; or Shrimp Scampi; or
Spinach Ravioli(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: 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
R.S.V.P. to Rasa Pizzi. Register on
the web, www.nemug.com , or
e-mail firstname.lastname@example.org .
We must receive your reply no later than Friday, May 12,
** No shows will be billed, unless cancellation is received by
Tuesday, May 16, 2017. **
SQL Writing Tips and Techniques
SQL is a very powerful language for processing data. There are
many ways to write SQL statements to get the desired results.
However, not all queries are created equal. This session will
compare and contrast different ways to approach a problem from
an SQL perspective. Whether it is writing queries or procedures,
taking the right approach for writing SQL can help the database
Rob Bestgen is an IBM DB2 for i architect and consultant. In his
29 year temporary assignment at IBM, Rob has held a variety of
roles including: database developer, database architect,
Business Architect, and chief architect of the DB2 for i SQL
Query Engine (SQE), to name a few. Rob is currently a proud
member of the DB2 for i Lab Services team, helping customers
utilize the amazing capabilities of DB2 for i, IBM i, and DB2
Web Query for i. Rob is also the product development manager for
DB2 Web Query for i, the popular IBM i product for query
reporting and analytics. Besides working directly with
customers, he is also a frequent presenter at user conferences.
President Dawn Dawson, The Moore Company (401) 315-6351 email@example.com
Vice President Chip DiFolco, Callico (774) 227-7373 firstname.lastname@example.org
Secretary Rasa Pizzi, Franklin Sports, Inc. (781) 573-2443,
(508) 944-1545 email@example.com
Treasurer Eileen Newell, FGX International (401) 719-2337
IBM Liaison Rick Cowles, IBM (781) 895-4714 firstname.lastname@example.org
Webmaster Jerry Perreault (401) 949-2613 email@example.com
NE Conference Liaison Chip DiFolco, Callico (774) 227-7373
firstname.lastname@example.orgMessage from the President
Message from the President
It has been
awhile since our last NEMUG meeting and wanted to take the time
to thank Jim Mason for presenting the object-oriented
programming language called GROOVY back in February. It was an
informative meeting. Thank You Jim! For May 17th we have Rob
Bestgen, an IBM DB2 for i architect and consultant. He is on his
29th year of "temporary assignment" at IBM. In his spare time,
he is a frequent presenter at User Conferences and User Groups.
We look forward to hearing him speak to us about SQL Writing
Tips and Techniques. Rob is a proud member of the DB2 for i lab
Services Team and will help all IBM i users to utilize the
amazing capabilities of DB2 for i.
Dawn Dawson, President NEMUG
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
to the following New and Renewing Member Companies
Franklin Sports, Inc.
|The Moore Company
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)
May 17 — SQL Writing Tips and
June 21 — What's new in DB2
for I, Jim Denton (IBM)
Evans says Thank You!
The next meeting
Wednesday, May 17, 2017
Manage your subscription to NEMUG emails
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
Click to see a 1968 midrange