OL38: Developing IBM i Applications Using SQL
DURATION: 2 days
SCHEDULED DATES: TBD – Contact Us for more Information
PURPOSE
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.
AUDIENCE
This course is designed for experienced IBM i RPG IV programmers who want to learn how to use SQL as a means to perform I/O to access the DB2 for IBM i database in their applications.
PREREQUISITES
Before attending this class, the student should be able to:
• Use a Windows-based PC
• Navigate IBM i menus and use IBM i commands
• Use SQL Data Definition Language (DDL) to describe tables and views
• Use the Program Development Manager/Source Entry Utility or the RSE LPEX Editor to code programs
• Use SQL SELECT statements to extract data from tables and views
• Use SQL UPDATE, INSERT, ALTER and DELETE statements to modify SQL tables
• Code SQL queries that include column and scalar functions
• Code SQL queries that include inner and outer joins
• Use the ILE Source Debugger
• Code RPG programs on the IBM i
• Prerequisite courses:
– OL370/OV370: Accessing the IBM i Database Using SQL
– OL490/OV490: IBM i Application Programming Facilities Workshop
OBJECTIVES
After attending this class, the student should be able to:
• Code embedded SQL statements in RPG IV programs
• Create and use simple stored procedures
