NEMUG
The New England Midrange Users Group

Home

Newsletter

Pictures

Schedule

About

Directions

Application

Contact an Officer

 Download Annual    Invoice

Home Page
 

   

 

Next Meeting - Wednesday, May 17, 2017 - SQL Writing Tips and Techniques

 

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 www.nemug.org


 

Date: Wednesday, May 17, 2017
Time:

Sign in 5:15PM; Speaker 6:00-7:15PM; Dinner to follow

Place: Jimmy G's Tavern (formerly Ambrosia Tavern), 116 Elm Street, North Attleboro, MA 02760
Topic: SQL Writing Tips and Techniques
Speaker: Rob Bestgen
Dinner: 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 door.

R.S.V.P. to Rasa Pizzi. Register on the web, www.nemug.com , or e-mail rpizzi@franklinsports.com .
We must receive your reply no later than Friday, May 12, 2017.
** 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 help you.

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.

I

NEMUG Officers

President Dawn Dawson, The Moore Company (401) 315-6351 ddawson@themooreco.com
Vice President Chip DiFolco, Callico (774) 227-7373 cdifolco@callico.com
Secretary Rasa Pizzi, Franklin Sports, Inc. (781) 573-2443, (508) 944-1545 rpizzi@franklinsports.com
Treasurer Eileen Newell, FGX International (401) 719-2337 ENewell@fgxi.com
IBM Liaison Rick Cowles, IBM (781) 895-4714 rcowles@us.ibm.com
Webmaster Jerry Perreault (401) 949-2613 gjpfromri@verizon.net
NE Conference Liaison Chip DiFolco, Callico (774) 227-7373 cdifolco@callico.comMessage 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 

       

E-mail Notification
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.

 

Welcome to the following New and Renewing Member Companies

(as of 10/31/16)

 

Aurora Technologies

Callico

FGX

Franklin Sports, Inc.

IntelliChief

JH Lynch

Jim Mason

The Moore Company

NATCO


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 Techniques

June 21 What's new in DB2 for I, Jim Denton (IBM)

 


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


 

Click for NEMUG Apparel


 
 

 

The next meeting
Wednesday, May 17, 2017

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

Maxava.com

iFoundation.com

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!

------------------------------------------
 
 

 
11-08

 

Copyright 2011-2012 New England Midrange Users Group

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

Top of Form