Summary
In this chapter, we concentrated on the SQL Data Definition Language (DDL). DDL is used to create, modify, and remove database objects. There are three main statements in DDL: CREATE, ALTER, and DROP. If you want to use a DB2 database, you may learn DDL first to create some database objects. There are many kinds of objects in a DB2 database. Some of them are created by a DB2 command, and some of them are created by DDL statements.
Here we focused primarily on data types, tables, views, and indexes among the database objects created by DDL. A data type is used to specify the attribute of columns in a table. DB2 has two kinds of data types: built-in data types and user-defined data types. The built-in type is a DB2-supplied data type and ...
Get DB2® Universal Database for OS/390® Version 7.1 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.
