Accessing the iSeries Database Using SQL

2 Day Course
Hands On
Official IBM Curriculum
Code OL37G

This course has been retired. Please view currently available IBM iSeries Training Courses.


SQL history (10 topics)

  • Concepts and terminology
  • Review of SQL DDL and DML
  • Using the STRSQL facility
  • Ops Navigator for database access
  • Extracting data using SELECT
  • Column and Scalar functions
  • JOIN and UNION operations
  • Subquery and Subselect
  • Database maintenance with SQL
  • Query tools, (STRQM, QMF for Windows)


Before attending this course, students should be able to: Use a Windows based PC Navigate and use a Windows based desktop Navigate iSeries menus Use iSeries commands List the data types that are supported by the OS/400 database Explain the use of the data types supported by the OS/400 database. Students can develop these skills by attending the OL49I and OL62 courses

Course PDF