The following examples show the standard report returned by HELP TYPE when you specify the ATTRIBUTE option.
The first example shows how the name for the structured UDT named address is returned with full qualification.
HELP TYPE address ATTRIBUTE;
Attribute Name street
Type CV
Max Length 20
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Char Type 1
UDT Name SYSUDTLIB.UDTName(assuming street is a UDT)
Attribute Name zip
Type CF
Max Length 5
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Char Type 1
UDT Name ?
The second example shows a report returned when the specified structured type insv_structured_smallint has multiple attributes, two of which are themselves structured UDTs.
HELP TYPE insv_structured_smallint ATTRIBUTE;
Attribute Name Attribute1
Type I2
Max Length 2
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Char Type ?
UDT Name ?
Attribute Name Attribute2
Type UD
Max Length 4
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Char Type ?
UDT Name SYSUDTLIB.UDTINT
Attribute Name Attribute3
Type UD
Max Length 50
Decimal Total Digits ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
Char Type ?
UDT Name SYSUDTLIB.UDTBLOB10