Use user-defined data types (UDTs) to extend your SQL functionality.
An Array is a type of UDT that can represent up to five dimensions, each with a user-defined maximum number of individual elements. All of the elements of an array must be of the same data type.
- 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.
- [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new UDT.
- Click Commit then OK.