IBM HTTP Server for AS/400
SQL Lab


Terms of Use
  1. You may freely download this file or set of files for use within your site or at your client sites.
  2. You must keep all of the original copyrights and other notifications with all copies of the file(s) that you download from this site.
  3. You may use any of the code or techniques described in your own programs.
  4. You may not develop any article, publication, Web page or other document that is based entirely or substantially on any of the information or code that you download.
  5. You may link directly to www.web400.com from any of your Web sites. Please do not link directly to internal pages on this site.
  6. Use of any materials, files, descriptions, code, procedures, etc., that you obtain from this Web site is AT YOUR OWN RISK. DO NOT USE any of the materials, files, descriptions, code, procedures, etc., if you are uncertain what the effect might be, and if you do not have adequate backup and recovery to correct any possible problems.
  7. I do not offer "free" support for any of the material available on this site. Consulting services are available by request for a fee.


File name: SQL Lab
Environment: iSeries 400 with OS/400 V5R1 or above, AS/400 Operations Navigator V5R1 or above, SQL Developer's Kit (5722-ST1)
Date Posted: October 4, 2001

About this document:
This is a "hands-on" lab that shows how to use several features of the AS/400 Operations Navigator SQL support. Includes extensive review of the new Database Navigator tool and how to create various SQL related objects on the iSeries 400. Also includes examples of the various types of joins and how you can create them using the "New View" option of Operations Navigator (also includes a practical example of a "cross join", which I am indebted to a seminar attendee for pointing out to me).

Note: this lab requires the V5R1 version of AS/400 Operations Navigator, OS/400 V5R1, and the SQL Developer's Kit (5722-ST1).
Link to the article:
SQLLab.pdf - PDF file that contains the SQL lab. (1519KB)


Craig Pelkie
Bits & Bytes Programming, Inc.
craig@web400.com

WEB400 Home Page Download Files


Web Server, AS/400
Copyright © 2001, Bits & Bytes Programming, Inc., ALL RIGHTS RESERVED

WWWSights, Publisher
Last modified October 4, 2001