This course is designed primarily to teach experienced IBM i RPG IV programmers how to use embedded SQL in IBM i RPG IV programs. As a secondary purpose, you also learn to create and use simple SQL stored procedures.
You should complete the following courses (or have the equivalent skills taught in these courses): Accessing the IBM i Database using SQL (OL37G) Developing IBM i Applications Using SQL (OL38G)
This intermediate course is for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform Input/Output (I/O) to access DB2 for i in their applications.
Code embedded SQL statements in RPG IV programs Create and use of stored procedures