Foreign Keys Wizard (DB2 Z/OS))
Go Up to IBM DB2 for z/OS Object Wizards
Foreign keys are unique values that refer to specific columns of other tables. Thus, a foreign key links two tables together. The Foreign Key Wizard makes it easy for you to create a relational link between two tables, thereby speeding queries and giving you faster access to data.The Foreign Key Wizard lets you create a foreign key without knowing the underlying commands.
To create a new foreign key using a wizard:
- Open a creation wizard for a foreign key. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Foreign Keys (DB2 z/OS) - Properties.
- Column Mapping panel - for details, see Foreign Keys (DB2 z/OS) - Column Mapping.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
Foreign Keys (DB2 z/OS) - Properties
When creating or editing a foreign key, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Table Schema |
Select the owner of the referencing, or child, table. |
Table Name |
Select the name of the referencing, or child, table. |
Name |
If you do not want to use the system-generated name, provide a new one. |
Delete Rule |
Select the action to be taken (NO ACTION, RESTRICT, CASCADE, or SET NULL) when a row of the referenced, or parent, table is deleted. |
Foreign Keys (DB2 z/OS) - Column Mapping
Under Referenced Table, choose the Owner and then the Name of the referenced, or parent, table.
Under the Main Table, select check boxes corresponding to the columns that are to reference columns in the referenced table. Then, under Referenced Table, select the corresponding column check boxes.