A structured UDT can have one or more attributes that can be based on predefined types or other UDTs. For example, an Address UDT might have street number, street name, city, state and zip code as attributes.
- In the Navigator, expand Databases, right-click the SYSUDTLIB database, and select Show User-Defined Types.
- In the Object List Viewer toolbar, click .
- Click the General tab and enter values for the new UDT.
- Click the Attributes tab and enter values for the new UDT.
- Click the Options tab and enter values for the new UDT.
-
Click Open SQL in Editor to see the SQL code that will be executed on the connected system to create the new UDT.
The property form closes; you will still need to save the UDT after viewing the SQL.
- Click to save the field information and any SQL changes you made.