Chapter 2. Database Objects
Creating Database Objects
Data Types
Tables and Tablespaces
Aliases and Synonyms
Constraints
Views
Indexes
DB2 is a relational database that consists of one or more tables that are made up of rows and columns. The tables are created and accessed using the industry standard SQL (Structured Query Language). Data in these tables is accessed via content, not location. This chapter looks at the structures in a DB2 subsystem and those that make up a DB2 database.
Many of these objects can be directly referenced from a SQL statement; therefore, it is important to understand their purpose. SQL is divided into three major categories:
DDL (Data Definition Language) is used to create, modify, or drop database objects.
DML (Data Manipulation ...
Get DB2® Universal Database™ for OS/390™ v7.1 Application Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
