January 2005 Newsletter Speakers: Charlie Massoglia - Dawn Food Products Leo Orsini - Application Specialists Topics: Embedded SQL Various SQL Topics Place: MSU Food Store 171 Service Road Lansing, MI (directions below) Times: Session 1: 4:00PM - 5:30PM Break: 5:30PM - 6:30PM Session 2: 6:30PM - 8:00PM Costs: Members: Free Non-Members: $25.00 Date: Wednesday - 01/19/2005

Session 1:

Speaker: Charlie Massoglia
Charlie Massoglia {MUH-SO'-LEE-UH} is Chief Information Officer for Dawn Food Products, Inc, one of the world’s largest independently owned bakery manufacturers and distributors. He is the author of a number of books and articles on the AS/400, System/38, System/36, System/34, and System/3. Charlie is a frequent speaker for COMMON US, COMMON Europe, Interaction Australasia, and other user groups worldwide. His cowboy hat has become the trademark for the Massoglia AS/400 Technical Seminars he has conducted throughout the United States and Europe. Charlie is currently a member of the Board of Directors of COMMON US.

Topics: Embedded SQL (With coverage of SQL basics)

• Review of SQL - terminology, SQL Statements, using joins
• Coding in RPG IV
• Exception Handling
• Processing Result Tables
• Using Variables

Session 2:

Speaker: Leo Orsini
Leo Orsini is a member of Application Specialists, a local IBM partner based in Mason Michigan. Leo has been a member of the AS/400 and iSeries community since 1986 when he joined the IBM Lansing office as a Systems Engineer. Leo's been with Application Specialists since 1993 and can't believe that almost twelve years have passed since he joined the company. 2004 was good to Leo and rewarded him with his first hole-in-one!

Topics: SQL

• SQL Stored Procedures
• Operations Navigator - Visual Explain
• Operations Navigator - SQL Scripting
• Intro to Cloudscape

Directions to MSU Food Store:
Exit off highway 127 on Trowbridge Rd (exits goes east).
Turn right on Harrison Rd (appx .75 mi).
Turn left onto Service Rd. (appx .1 mi).
171 Service Drive = MSU Food Stores.
Parking on West side of building.