Defining columns and rows in a table
After logical and physical database design is complete, you implement the definitions that were created during physical design. This section describes how to implement:
Columns. See “Determining column attributes”
Data types. See “Choosing a data type for the column” on page 224
Null and default values. See “Using null and default values” on page 233
Check constraints. See “Enforcing validity of column values with check constraints” on page 237
Throughout the implementation phase of database design, refer to the complete descriptions of SQL statement syntax and usage for each SQL statement that you work with.
Determining column attributes
A column contains values that have the same data type. If you are familiar ...
Get Official Introduction to DB2® for z/OS®, The, 2nd Edition 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.
