UDT

The UDT command displays information about the source data type for a DISTINCT type. The UDT command can be used to display information about one or more distinct types on any panel that contains a distinct type.

Blank

Only valid for browse or edit. Enter the UDT command with the cursor placed on a distinct type column header or distinct type column. The UDT Definition window displays the built-in data type information for the selected distinct type (see the following figure).

Distinct Data Type Definition window

Name

Name of the DISTINCT type to be displayed. Wildcards (*) are valid.

Schema

Name of the schema associated with the DISTINCT type to be displayed. Information for one or more DISTINCT types displays (see the following figure).

Distinct Type Information pop-up

Autocast Feature

Autocast automatically casts a DISTINCT type field to its source data type and scale, and is set on the Browse/Edit Display Options screen (Browse/Edit/SQL Analysis Display Options screen (Part 2)). Automatic casting is applied to the field on the left-hand side of a WHERE clause if and only if the WHERE clause contains no fields that are DISTINCT types. This applies in edit, browse, copy, and extract/load.

When you select a distinct type row, the Autocast Warning window displays, where you can select whether to apply the cast or not, and whether you want to see the pop-up in the future (save the setting you choose).

Autocast Pop-up