|
Field or Control Name |
Description |
|
Type Name |
A list of all available UDTs. To create a new type, enter a new name. |
|
Distinct |
Select to clone an existing data type and add additional restrictions, or functionality, to the clone. 1 |
|
Structured |
Select to create a data type with multiple fields.2 |
|
Array |
Select to create an array type. |
|
Comment |
Type any descriptive text. |
Examples
1 Distinct data type: Define ‘Salary’ as a Decimal(9,2), but with a function that prevents someone from entering a value of less than 20,000 or more than 2,000,000.
2 Structured data type: If ‘Address’ is defined as a UDT with sub-fields for Street, Apartment, City, State, and Zip Code, Transform functions must be provided that convert input and output data into and from an ‘Address’ object. Suggest inputting and outputting it as a string with all the fields concatenated, either using fixed field lengths or a delimiter such as a comma between them.
3 The following table demonstrates how the values entered in the Bounds text box are handled as SQL values.
|
Values entered |
Result |
|
10 |
|
|
1:5,10:20 |
|