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.
Code embedded SQL statements in RPG IV programs
Create and use of stored procedures
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.
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)
Unit 1. SQL review
Lab exercise: SQL review
Unit 2. Using embedded SQL
Introducing embedded SQL
Lab exercise: Change CHAIN to SELECT
Writing programs that use embedded SQL
Lab exercise: Changing native to SQL I/O
Using a cursor for multiple row result set
Lab exercise: Using a cursor
Using embedded SQL (continued)
Dynamic embedded SQL
Lab exercise: Dynamic embedded SQL
Unit 3. An overview of stored procedures
Introducing stored procedures
External stored procedures
Lab exercise: Create a stored procedure
SQL stored procedures
Prior to enrolling, IBM Employees must follow their Division/Department processes to obtain approval to attend this public training class. Failure to follow Division/Department approval processes may result in the IBM Employee being personally responsible for the class charges.
GBS practitioners that use the EViTA system for requesting external training should use that same process for this course. Go to the EViTA site to start this process: http://w3.ibm.com/services/gbs/evita/BCSVTEnrl.nsf
Once you enroll in a GTP class, you will receive a confirmation letter that should show:
The current GTP list price
The 20% discounted price available to IBMers. This is the price you will be invoiced for the class.