Loading…
Tuesday, June 19 • 13:45 - 14:45
Embedded SQL in RPG - Beyond the Basics

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
You have been using embedded SQL in RPG. You have mastered the syntax, tried a few selects, declared a cursor, performed an update - you may even have tried some dynamic SQL!Time to take it to the next stage and see what you can do with embedded SQL - beyond the basicsTopics covered in this session include:-Discussion of the key points in writing powerful embedded SQLControlling CRTSQLRPGISQLCA and SQLCODE considerationsGetting data without SELECT - GET DIAGNOSTICS and VALUES INTOTalking to Watson with Embedded SQLMaking use of Scalar FunctionsMastering Multi Row FetchHandling NULLDates, Times and Timestamps

Speakers
avatar for Paul Tuohy

Paul Tuohy

ComCon and System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Tuesday June 19, 2018 13:45 - 14:45 CEST
Orchidea A