Module 21 - DB2/SQL

Module 21 - DB2/SQL 

Mon August 31, 2020 04:18 PM

  • DB2 and the Relational Model
  • The Elements of DB2
    • Architecture
    • Data Objects
    • DB2 Catalog
    • Tables
  • DB2 Development Tools
    • DB2I/SPUFI
    • IDz
  • Accessing information in DB2 Tables - SQL/DML
    • All rows/All columns - All rows//Some columns - Some rows/All columns - Some rows/Some columns
    • SQL Predicates
    • Derived Column Values
    • Table Joins
  • Accessing DB2 from COBOL
    • APIs
    • Singleton Select, Set-Level Select Statements
    • Update/Delete/Insert
    • DCLGEN
    • Build