Omni Banner

The Modern SQL Language Fun with SQL
Bob Cozzi

Tuesday August 18th 2015

Richard Schoen

Casey's Restaurant and Bar (new location)
415 E. North Avenue (IL-64), just East of I-355
Lombard IL

5:00 Registration
6:00 Dinner and Business Meeting
7:00 Presentation

meals | register | cancel | directions

This session shows you several working examples of SQL that you can take home and start using immediately. Several queries (SQL SELECT statements) are provided to retrieve information that is already on your machine, such as Joblogs, disk info, PTFs, object info, and basic system information. We'll show you how to redirect their output to various output formats. In addition, using SQL to displace classic CL tasks, such as RUNQRY, CPYF, CLRPFM, CRTPFM are illustrated for your reference. Lastly, 3-level names are reviewed to help you get a better understanding of how to use SQL to query data on another partition or a remote system.

Bob Cozzi

Bob Cozzi has been providing solutions for the IBM i platform for over 35 years. From the original "Q38 Technical Journal" to "Midrange" magazine, to his RPG books and "RPG World" conferences, to the free IBM i community website he founded, Bob has been helping IBM i shops by providing the kind of information they need today. Currently he focuses on developing his two core products, Cozzi Tools, a popular collection of IBM i tools and utilities, and SQL Query File, a contemporary way to run SQL queries and direct the output to any format.

Dinner Options
Food and Drink are ala carte from

August Dinner Meeting Registration
Please make your reservations by Friday August 14th 2015.

To register, please do these 2 things...
1) Please submit your information using the form below to express your preferences.
2) Please pay for your registration on The Omni User Store by clicking one of the store links.
Thanks in advance!

Please pay for your registration on The Omni User Store

First name:
Last name:
Address 1:
cc billing address
Address 2:

Registration Options:
2015 Omni Membership will be verified at the check-in table.
Non-registrants (walk-ups) must pay a $5 surcharge to register at check-in.
$15 Members
$40 Non-Member

Membership Options:
Add $50 2015/2016 Individual Membership
Add $240 2015/2016 Corporate Membership
Don't add a membership

LUG Affiliation:
Southwest Michigan
Gateway/400 Group

Have you visited The Omni User Store to purchase your registration?

Please click the button below to submit your information...

Please pay for your registration on The Omni User Store

Please invite your friends and associates to join you at the Omni Dinner Meeting. Send them a message to tell them you'll be attending for education, networking, and so much more. For some, it might be a great reason to reconnect with a phone call. Omni appreciates everything you do to spread the word about your best value in IBM i on Power Systems education!
Dinner Meeting Cancellation Policy
Full credit will be issued for cancellations made before 9:00 am Friday August 14th 2015.
After 9:00 am Friday August 14th 2015, cancellation credit depends on meeting attendance.
All cancellations must be made by using the web cancellation feature below (the preferred method) or, if you must, by calling (630) 953-6312 and leaving the name(s) of those unable to attend.


Dinner Meeting Directions

The event will be held at Casey's Restaurant and Bar (new location) at 415 E. North Avenue (IL-64), just East of I-355 in Lombard, IL

Casey's Restaurant and Bar in Lombard is located on the South side of North Avenue (IL-64) east of I-355.

Click here for a map!

For more information
email questions to Jerome Hughes or leave a message on the OMNI line at (630) 953-6312

events | membership | by-laws | board | links | downloads | home

2021 Midwest Road, Suite 200 Oak Brook IL 60523

opinions craved!
email webmaster

2002-2015 The Omni User