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 forstie@us.ibm.com. Scott is an avid runner and enjoys cooking.