SQL is playing an ever-increasing role in the IBM i operating system (aka iSeries, AS/400) in enterprise database design, supplanting legacy DDS. This class shows you how to embed SQL statements into your RPG IV programs to combine the best of SQL and RPG IV. It also introduces the concept of SQL stored procedures.
Recommended schedule: 2 days
Who Should Attend This class is for existing RPG IV programmers who want to understand embedded SQL programming concepts in an RPG IV environment.
Prerequisites In order to successfully complete this course, students should have completed the following courses, or have equivalent knowledge/experience:
IBM i Concepts and Programming Tools
RPG IV and the Integrated Language Environment
SQL: Database Design and Access
This class may be combined with the SQL Database Design and Access classes.
What You Will Accomplish At the end of the course, students will be able to:
Incorporate SQL statements into RPG IV programs for simple record selection
Use SQL to retrieve sets of records into an RPG IV program
Use SQL to perform mass record updates in an RPG IV program
Build SQL queries dynamically (“on the fly”) in an RPG IV program
What You Will Receive Each student receives:
Custom printed handout, containing class notes
Course Outline The class covers these topics:
Basic Elements of Embedded SQL
Free format RPG IV with Embedded SQL
Static vs Dynamic SQL
Using Host Variables, Structures
Compiling Embedded SQL
SQL Cursors and Fetch
Introduction to Stored Procedures
Embedded SQL and the Integrated Language Environment
Using SELECT INTO
Using Static Embedded SQL
Using Serial Cursors
Single- and Multi-row Updates
Using Dynamic Embedded SQL
Using Positioned Update and Scrollable Cursors
Special pricing for the
Seattle area. Book a 5-day onsite class for as little as USD $1100/day. Get a price quote today. Ask for offer WA11.
It is your responsibility to ensure procedures, techniques, and code used from this website are accurate and appropriate for your installation. No warranty or support is implied or expressed.
AS/400®, eServer, i5/OS, IBM i, Integrated Language Environment®, iSeries, OS/400®, RPG/400®, System i5, VisualAge®, and WebSphere® are trademarks of IBM Corporation. Note: IBM® i is the operating system used by IBM's Power Systems and iSeries servers. This site might refer to these servers as System i, iSeries, or AS/400.