O'Reilly logo

DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition by Paul C. Zikopoulos, George Baklarz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Database Objects

• CREATING DATABASE OBJECTS

• DATA TYPES

• TABLES

• CONSTRAINTS

• VIEWS

• INDEXES

The standard language of relational database access is SQL (Structured Query Language). SQL is not a conventional programming language. It was designed for the purpose of accessing tabular data. Every Relational Database Management System (RDBMS) implements a slightly different version of SQL.

In this chapter we examine the DB2 implementation of the SQL language. If you are familiar with other RDBMS products, you will already understand many aspects of the DB2 implementation of SQL thanks to the industry acceptance of the ISO®/ANSI® SQL standard.

We first examine the DB2 database objects that can be referenced in an SQL statement; then, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required