Creating tables for DEDB databases
When defining a new table for a DEDB, use the CREATE TABLE statement. You will define the physical characteristics of the table and its relationship with other tables. Its hierarchy in the database is determined by the FOREIGN KEY clause.
Consider the following when creating a new table for a DEDB:
- At least one table with a maximum of 127 tables for the database.
- 0-255 columns for each table, and a maximum of 1000 for the database, one of which must be a unique sequence field for the root segment type.
- Optional Editproc identifying an edit/compression exit routine to enable user-supplied routines to manipulate each occurrence of a table on their way to or from auxiliary storage.
- Optional maximum of 8 subset pointers for each child of the parent.
- Optional Data Capture exit routine, to enable DB2® for z/OS® users access to updated IMS data.
- You cannot specify a logical relationship between tables.