This example shows the standard report returned by HELP TYPE for a distinct UDT type.
Suppose you create the following ARRAY type.
CREATE TYPE mydistinct AS INTEGER FINAL;
This type returns the following report to a HELP TYPE request.
HELP TYPE mydistinct;
Result:
Name mydistinct Internal Type UD External Type I Max Length 4 Decimal Total Digits ? Decimal Fractional Digits ? Contains LOB N Ordering F Ordering Category M Ordering Routine SYSTEM Cast Y Transform Y Method N Char Type ? Array (Y/N) N Dimensions ? Element Type ? UDT Name ? Array Scope ?