January 2005
Beginner to intermediate
928 pages
22h 14m
English
A table is an unordered set of records, consisting of rows and columns. Each column has a defined data type, and each row represents an entry in the table. Figure 7.9 shows an example of a table with n rows and m columns. The sales_person column with a VARCHAR data type is the first column in the table, followed by the region column with a CHAR data type. The year column is the mth column in the table and has an INTEGER data type.

Tables in DB2 can be classified as illustrated in Figure 7.10. You will learn more about each of these tables in the next sections.
Read now
Unlock full access