AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage

FREE AS/400, iSeries, and System i / iSeries Downloads
HOME >> FREE AS/400, iSeries, and System i / iSeries Downloads >> SQL - Using SQL with the iSeries

SQL - Using SQL with the iSeries
Author: Craig Pelkie


Rel Level
Using SQL with the iSeries Lab This lab presents an overview of the SQL features available in the AS/400 Operations Navigator, V5R1. In the lab, you create an SQL collection and tables, work with key and check constraints and add a referential constraint.

You'll use graphical tools to visually create views and work with the five view types: INNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN, EXCEPTION JOIN and CROSS JOIN.

The lab shows how to effectively use the new Database Navigator feature of AS/400 Operations Navigator. It is an excellent introduction to both SQL and the AS/400 Operations Navigator SQL functions.

Note: the lab uses OS/400 V5R1 and AS/400 Operations Navigator V5R1. If you are running an earlier release of either software product, some of the features described in the lab will not be available to you.

Note: you do not need the SQL Developer's Kit installed on your iSeries / AS/400 to take advantage of the tools described in this document.
V5R1 2 hours 54