SQL for iSeries/i5 Users

Audience

i5 and iSeries users who wish to access data and use the facilities provided by SQL. Programmers who need to understand and use SQL in their work.

Prerequisites

A good familiarity with the iSeries 400 and its database is expected. Users who are familiar with using Query/400 or programmers would be suitable.

Duration

2 days. Hands on.

Course Objectives

After attending delegates will be able to:

• Access SQL DML and DDL using STRSQL
• Use the Operations Navigator interface
• Use SQL statements to extract and update data
• Create and drop files (tables)
• Use the SQL Query Manager

Course Content

Introduction to SQL DDL/DML
SRTSQL and Ops Nav
Select
Join
Grouping data
Scalar and Group Functions
Insert, Update, Delete
Union
Subselect
Create and Drop