The Power of SQL on IBM i — Scott Forstie

  • What is SQL
  • Why SQL is important
    • Integrated in o/s
    • SQL services
  • What are the parts?
    • DDL
    • DML
    • Programming language
  • What you can access with SQL (High level overview)
    • JSON/XML
    • IFS access
    • Accessing web services
  • Terminology differences
    • File
    • Table
  • Database objects
    • Schema
      • Table
      • View
      • Indexes
        • Why they are necessary
    • SQL routines
  • Insert from examples
  • Where to go for all documentation (IBM sources and COMMON LMS sources), word of warning of Google searches

Scott Forstie

Db2 for i Business Architect

Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. He has worked on IBM operating system development since joining IBM in 1989.

Scott is a frequently published author, speaker at industry events around the globe and can be found @Forstie_IBMi and Scott is an avid runner and enjoys cooking.


Open to view video.
Open to view video.