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


SQL

 
File
 
Type
 
Description
Minimum
Rel Level
Reading
time
 
Pages
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