Omni Banner


Writing Cross-Platform SQL
Andrew Clark


Tuesday January 17th 2017

Andrew Clark

IBM Oakbrook Terrrace
18W140 Butterfield Rd
Oakbrook Terrace IL

5:00 Registration
6:00 Dinner
7:00 Presentation

meals | register | cancel | directions

Today our data is often duplicated and spread across multiple databases and operating systems. Unfortunately, each database has its own syntax and "idiosyncrasies" - the exact same SQL statement often won't work even if the schemas are identical. This session will help you leverage existing SQL experience against multiple databases, and provide some advanced techniques that you can use even if you only work with DB2. Highlights include User-Defined Functions (UDFs), Common Table Expressions (CTEs) and derived files.

Andrew Clark

Andrew Clark is an independent consultant who has been working on the IBM i platform for more than 25 years, beginning with the "super-secret" Mankato project on a pre-release version of OS/400 and an internship at IBM Rochester working on the Query (QQ) team. He has experience in multiple languages (C++, MI, Java, VB, RPG, COBOL, PLI, CL, JavaScript, Delphi, PHP, ExtJS, etc.) and a background in green-screen, Windows, mobile and web development. He is an expert on everything DB/SQL on IBM i and has also worked extensively with SQL Server, Oracle, Postgres, DB2/LUW and Jet.

 
Dinner Options
Free Pronto Catered Italian Buffet with Sliced Beef, Cheese Ravioli, Wedge Potatoes, Big Ass Salad, Bread, and Dessert, sponsored by Pinnacle Business Systems

January Dinner Meeting Registration
Please make your reservations by Monday January 16th 2017.

First name:
Last name:
Title:
Company:
Address 1:
Address 2:
City:
State:
Zip:
Telephone:
Email:

Registration Options:
$.01 Member ($.01 not collected)
$25 Non-Member (or Add $50 2017 Membership, attend this meeting free!)

Membership Options:
Add $50 2017 Individual Membership
Add $240 2017 Corporate Membership
Don't add a Membership


User Group Affiliation:
Omni
COMMON
WMCPA
MUGNI
QUSER
Southwest Michigan
Gateway/400 Group
Other:


To register, please do these 2 things...
1) Please submit your information by clicking the "Submit Information" button below.
2) If you're not a paid 2017 member who gets this one free, please pay for your membership or registration on The Omni User Store by clicking the store link.
Thanks in advance!

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

And, if you're not a 2017 member who gets this one free, please pay for your membership or 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 Monday January 16th 2017.
After 9:00 am Monday January 16th 2017, 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.

images/Cancel.gif

Dinner Meeting Directions

The event will be held at IBM Oakbrook Terrrace at 18W140 Butterfield Rd in Oakbrook Terrace, IL

The Dinner Meeting will be held in the 16th floor classroom 1252.

map
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
www.omniuser.org

opinions craved!
email webmaster
630.953.6312

© 2017 The Omni User