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, June 19, 2019 - 30 SQL Tips in 60 Minutes

 

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:  June 19, 2019
Time:

 Sign in 5:15p.m.; Speaker 6:00-7:15p.m., Dinner to Follow

Place: Red Stone Grill, 120 Chestnut Street, North Attleboro, MA 02760 
Topic:

Data Availability and Security Overview for the IBMi

Speaker:  Ted Holt - Profound Logic
Dinner:

Shepherd’s Pie - Prepared the traditional way we all know and love. Layers of ground beef, buttered corn and creamy mashed potatoes then baked to perfection and served with a side of gravy 

Chicken Parmesan - Breaded chicken breast topped with our house made tomato sauce and melted mozzarella cheese; served over penne pasta

Baked Haddock - Fresh haddock filet topped with a buttered Ritz Cracker topping. Served with rice & seasonal vegetables

Vegan or Vegetarian – Available on request

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

We must receive your reply no later than Friday, June 14, 2019
 ** No shows will be billed, unless cancellation is received by Tuesday, June 18, 2019

 

 

 

Thirty SQL Tips in Sixty Minutes - Ted Holt


SQL is THE data access language. It runs interactively from green screens and System i Navigator. It's in RPG and COBOL programs, in ODBC and JDBC. It's ubiquitous, and it's everywhere, too! You can't know too much about SQL. In this session, Ted Holt presents an assortment of powerful, effective, and easily implemented SQL tips and techniques.

These tips and techniques are based on DB2 for i, but many of them apply equally to other platforms. There's something for everyone, from the SQL novice to the advanced user. Come learn some new techniques and reacquaint yourself with some you may have forgotten.

Bio:

Ted Holt is a Senior Software Developer with Profound Logic Software, a provider of modernization solutions for the IBM i world. He has worked within the information technology industry since 1981, primarily with IBM midrange computers. His industry experience includes the fields of manufacturing, healthcare, education, retail, and wholesale. He holds a master's degree in computer science from the University of Southern Mississippi and has taught in community colleges, universities, and vocational/technical schools.

Ted is the author of several books on programming topics, including OpenQuery File Magic!, Complete CL, Power CL, Qshell for iSeries and the MC Press Encyclopedia of Tips, Techniques, and Programming Practices for iSeries and AS/400. He is a regular speaker for the RPG and DB2 Summit and serves as technical editor and writer for Four Hundred Guru, a technical newsletter published by itjungle.com

 

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  

Rick Marcotte

iTech Solutions  

(508) 243-3508

 

rmarcotte@itechsol.com

Treasurer  

Eileen Newell,
FGX International
  

(401) 719-2337  

enewell@fgxi.com

Webmaster  

Rick Marcotte

iTech Solutions

(508) 243-3508

rmarcotte@itechsol.com

NE Conference Liaison  

Chip DiFolco,

Callico

(774) 227-7373

cdifolco@callico.com




President's Message:

At our last NEMUG Meeting in May, Barry Kirksey discussed ways to ensure your data is Highly Available and Secure using SyncSort's MIMIX and Assure products.  It was a great discussion and many questions were answered.  We had a great turnout for Barry's presentation.  Thank you Barry for joining us at our NEMUG meeting for the evening.

On June 19th, we have Ted Holt, a Senior Software Developer for Profound Logic, a provider of modernization tools for the IBM i.
 He has worked within the information technology industry since 1981, primarily with IBM midrange computers. His industry experience includes the fields of manufacturing, healthcare, education, retail, and wholesale. He holds a master's degree in computer science from the University of Southern Mississippi and has taught in community colleges, universities, and vocational/technical schools.

Ted will be joining us at the June NEMUG Meeting to present his "Thirty SQL Tips in 60 Minutes" presentation which was well-received at the recent New England User Group Conference.


Dawn Dawson

NEMUG President

     

 

NOTE: As mandated in our by-laws, annual elections will be held at this meeting. Anyone interested in an office please notify us prior to the start of this meeting to be added to the candidate pool


 

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 5/1/2019)

 

Callico Distributors

FGX International

Franklin Sports
iTech Solutions Group
JH Lynch & Sons, Inc.
The Moore Company

NATCO Products Corp.

Cape Cod Bay Systems
IntelliChief


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.
 

Thank you for your support of NEMUG!

 

 
 

 

The next meeting
Wednesday, June 19, 2019

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

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 Rick Marcotte  -- Last updated June 07, 2019 -- Best Viewed at 800x600

Top of Form