Loading…
This event has ended. Visit the official site or create your own event on Sched.
** CONGRESS GUIDE **
View analytic
Sunday, June 18 • 13:00 - 17:00
Hands-On: SQL for the RPG Programmer!

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
SQL is being used more and more by the RPG programmer. Not only is SQL replacing DDS for defining databases but it is being used extensively within RPG programs.
This half day workshop concentrates on the how to code SQL's Data Manipulation Language (SELECT, INSERT, UPDATE, DELETE) and how to embed SQL in RPG programs. There is also an overview of SQL's Data Definition Language (DDL) . It is assumed that the attendee has some basic SQL language experience - such as using interactive SQL to query a table.
Topics include:-
• Data Manipulation Language (DML)
o Retrieving Data (SELECT, FROM, WHERE, ORDER BY)
o Updating Data (INSERT, UPDATE, DELETE
o GROUP BY, HAVING, Column Functions
o SQL Functions
o Selecting From Multiple Tables/Views
• Embedded SQL
o Basic Syntax
o Using host variables
o Using a SELECT statement
o Using a Cursor
o Identifying and handling errors
o The power of INSERT, UPDATE and DELETE
o Compile options

Speakers
avatar for Paul Tuohy

Paul Tuohy

Owner, ComCon Consultancy
Paul Tuohy has specialized in application development and training on IBM midrange systems for more than 20 years. | He currently runs ComCon consultancy and is a partner in System i Developer and the RPG & DB2 Summit. He is also a technical editor for iPro Developer, the autho... Read More →


Sunday June 18, 2017 13:00 - 17:00
ROOM 15/16/17

Attendees (3)