NEMUG
The New England Midrange Users Group

Home

Newsletter

Pictures

Schedule

About

Main Menu

Members

Speaker Info

Directions

Application

From the President

Speaker Handouts

Contact an Officer

 Download Annual    Invoice

 

Home Page
 

   

 

Next Meeting - Wednesday, November 19, 2014 - SQL

 

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, November 19, 2014
Time: Sign in 5:15PM; Speaker 6:00-7:15PM, Dinner to follow
Place: Ambrosia Tavern, 116 Elm Street, North Attleboro, MA 02760
Topic: SQL Tips and Tricks
Speaker: Bryan Meyers, Enskill.com
Dinner: Maple Glazed Salmon served with roasted potatoes and vegetables; or Chili Chicken with onions and peppers served with basmati rice and raita; or Sirloin Tips served with mushrooms, onions, baked potato and vegetables, or Pasta Primavera (Vegetarian with penne).  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, www.nemug.com and pay at the door.

R.S.V.P .  to Aurora Technologies.  Register on the web, www.nemug.com
 or e-mail aurora@auroratechedi.com
or call: (401) 765-3721, FAX. (401) 766-4591.  Include your name, company, e-mail address, number attending and your meal choice.  We must receive your reply no later than Friday, November 14, 2014.
 ** No shows will be billed, unless cancellation is received by Tuesday, November 18, 2014. **


Introduction To Embedded SQL

In this session we’ll introduce the basic elements behind embedding SQL statements into an RPG IV program. The session will cover the syntax requirements, and discuss when embedded SQL is appropriate. You’ll understand the differences between static and dynamic SQL statements. We’ll cover how to interact between SQL host variables and RPG variables, as well as indicator variables, host structures, and indicator structures. Regardless of what IBM i release you have installed, we’ll talk about the best way to integrated SQL statements with free format RPG code, and how embedded SQL works with RPG subprocedures and local variables.

Bryan Meyers is well known to IBM i technicians as the author of a number of popular books and frequent magazine articles. His programming, management and consulting career has spanned most of the IBM midrange history, from the System/360 through the AS/400, iSeries, and IBM i. For much of that time, Bryan was the IT Director for an international hospitality franchisor. He has also managed computer operations for municipal government, international construction, and broadcasting media industries. Currently, Bryan offers on-site corporate training classes in IBM i technical topics, as well as online programs. Bryan’s most popular books include RPG IV Jump Start, Programming in RPG IV, and Control Language Programming for IBM i, all recognized as benchmark references in the IBM i community.

 


 

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 (aurora@auroratechedi.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!

A & H Worldwide
A.J. Oster
Aurora Technologies
Callico
Cape Cod Bay Systems
Compu-Call
FGX
Hart Engineering
IntelliChief
iTech
Jerry Perreault
Jewel Case Corporation
JH Lynch
John Dowling
K & M Associates
NATCO
National Amusements
Sterngold
Teamsters Pension Fund
The Moore Company  

Message from the Vice President


For our October 15th meeting, Robin Tatum, from Power Tec came in from Minneapolis to present his session on Top Ten Security Risks on the IBM i.  With increasing occurrences of data breaches and unauthorized system access this session was pertinent to all of us and we took home information we could use at the office the next day.  We hope to see Robin in the future and learn more about security on the IBM i.

For our November 19th meeting, Bryan Meyers is coming to talk with us about a great programming tool—Structured Query Language.  SQL support only started on the AS/400 with V1R1.  At that time, AS/400 SQL performance was a problem and a turnoff for most developers.  Many iSeries developers still consider SQL an optional skill, but today one can barely get by as a programmer without knowing SQL.  Join us at this meeting and learn what it can do for you! 

Bryan Meyers is well known to IBM i technicians as the author of a number of popular books and frequent magazine articles.  His programming, management and consulting career has spanned most of the IBM midrange history, from the System/360 through the AS/400, iSeries, and IBM i.  For much of that time, Bryan was the IT Director for an international hospitality franchisor.  He has also managed computer operations for municipal government, international construction, and broadcasting media industries.  Currently, Bryan offers on-site corporate training classes in IBM i technical topics, as well as online programs.  Bryan’s most popular books include RPG IV Jump Start, Programming in RPG IV, and Control Language Programming for IBM i—all recognized as benchmark references in the IBM i community.

We look forward to meeting Bryan and seeing everyone at the next meeting!

Dawn

 

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


 
 

 

November 19, 2014 
The next meeting

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 November 06, 2014 -- Best Viewed at 800x600

Top of Form