SQL Basics for RPG Developers
Note: This is the 1st in a series of SQL topics MMSA will be presenting. An intermediate and advanced session will be coming in the next few months.For modern System i development, SQL is a must these days. This session will cover some of the basics that all System i developers need and should know, including interactive SQL and the options available within. And, in addition to commands such as the SELECT, UPDATE, and DELETE, we will cover Columnar Functions and Result Sets for embedded SQL.
After attending this session, you will be able to query and update data using interactive SQL, embed basic SQL statements in your RPG applications, and be prepared to attend MMSA's intermediate SQL session in the coming months.
A MUST FOR NEW DEVELOPERS!
BIOGRAPHY:
Chris Adair has over 20 years experience developing applications on the AS/400, iSeries, and System i. Most of which has been here in Dallas where he is the Manager of Development for National Envelope. At National Envelope, Chris is responsible for the maintenance and development of the manufacturing and distribution systems, along with the JDE World Financials.
As an IBM Certified Developer, Chris not only enjoys learning the newer technologies, but also applying those newer technologies and techniques to existing applications.
Past Meetings
Click here to see a list of all past MMSA Meetings.
COMMON's Archived Webcasts
Webcasts are exclusively free for COMMON members, and offer a great option to stay up-to-date on the latest in Power Systems-related education. They are delivered by recognized speakers, and offer members the flexibility to participate in the hour-long Webcasts from anywhere they have Internet access.
The monthly Webcasts are also archived, creating a great knowledgebase of Power Systems-related education that you can access at your own leisure and review them at your own pace. COMMON Webcasts have immeasurable ROI on your membership dollars, giving you access to leading-edge education that can immediately impact your work, without any additional cost. Below are some of the recent COMMON Webcasts that have taken place...all available free to COMMON members, and delivered by industry experts on the latest topics.
- Mobile
and Cloud Computing with the IBM i
Speaker: Eamon Musallam, looksoftware - Everything
You Need to Know to Get Started with the New Systems Director
Navigator Console
Speaker: Pete Massiello, iTech Solutions Group - Enhancing
Your Existing RPG Applications with PHP
Speaker: Brian May, Garan Incorporated - AIX
Business Resiliency and Disaster Recovery
Speaker: Ferenc Gyurcsan, Vision Solutions - IBM
i Performance Data Collectors and Investigator
Speaker: Dawn May, IBM - Best
Practices for IBM i Performance Management
Speaker: Dawn May, IBM - What
You Need to Know and Understand to do Successful IBM i
Upgrades 6.1.1 & 7.1
Speaker: Pete Massiello, iTech Solutions Group, LLC - Open
Source Report Writing Tools for IBM i
Speaker: Pete Helgren, Value Added Software, Inc. - IBM
i 7.1 Overview
Speaker: Steve Will, IBM
View the complete list of archived Webcasts and access them at http://www.common.org/index.php/webcasts/archived-webcasts.html
Learn more about upcoming Webcasts and register online at http://www.common.org/index.php/webcasts.html
