Online Documentation for SQL Manager for DB2

Creating/editing UDS type


Use the Edit tab of UDS Type Editor to create/edit a user-defined structured type and specify its definition.

 

UDS Type Editor - Editing UDS Type definition

 

 

Structured type schema

Use the drop-down list to select the schema for the user-defined structured type.

 

Name

Enter a name for the new user-defined structured type. Note that the name must not identify any other type (built-in, structured or distinct) already described in the catalog.

 

 

Inherits from

Select the source for the new UDS type.

 

RadioButton Supertype

 

Supertype schema

Use the drop-down list to select the schema where the source supertype is located.

 

Supertype name

Use the drop-down list to select the source supertype name.

 

RadioButton Ref using

 

Data type

Use the drop-down list to select the built-in data type used as the representation (underlying data type) for the reference type of this structured type and all its subtypes.

 

Inline length

Use the spinner control to indicate the maximum size (in bytes) of a structured type column instance to store inline with the rest of the values in the row of a table.

 

Options

 

CheckBox Instantiable

Determines whether an instance of the structured type can be created.

 

CheckBox Not final

Indicates that the structured type may be used as a supertype.

 

CheckBox With function access

Indicates that all methods of this type and its subtypes, including methods created in the future, can be accessed using functional notation.