Creating types
CREATE TYPE NameType AS (FirstName char(30), MiddleName char(30), LastName char(30), Title char(30)) MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE PersonType AS (Name REF(NameType), Mother REF(NameType), Father REF(NameType)) MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE MarriageType AS (DateMarriage DATE, Husband REF(PersonType), Wife REF(PersonType)) MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE ProductType AS (maker CHAR(10), model INTEGER, type CHAR(10)) REF USING INT MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE PCType AS (product REF(ProductType), speed INTEGER, ram INTEGER, hd INTEGER, rd CHAR(10), price INTEGER) REF USING INT MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE LaptopType AS (product REF(ProductType), speed INTEGER, ram INTEGER, hd INTEGER, screen INTEGER, price INTEGER) REF USING INT MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TYPE PrinterType AS (product REF(ProductType), color CHAR(1), type CHAR(10), price INTEGER) REF USING INT MODE DB2SQL
DB20000I  The SQL command completed successfully.

CREATE TABLE Product_udt OF ProductType (REF IS ProductID USER GENERATED)
DB20000I  The SQL command completed successfully.

CREATE TABLE PC_udt OF PCType (REF IS PCID USER GENERATED, Product WITH OPTIONS SCOPE Product_udt)
DB20000I  The SQL command completed successfully.

CREATE TABLE Laptop_udt OF LaptopType (REF IS LaptopID USER GENERATED, Product WITH OPTIONS SCOPE Product_udt)
DB20000I  The SQL command completed successfully.

CREATE TABLE Printer_udt OF PrinterType (REF IS PrinterID USER GENERATED, Product WITH OPTIONS SCOPE Product_udt)
DB20000I  The SQL command completed successfully.