The following examples show two instances of the SHOW TYPE report for a UDT.
To report cast information for a UDT, you must use the SHOW CAST statement.
SHOW TYPE UdtInt;
Result:
*** Text of DDL statement returned. *** Total elapsed time was 2 seconds. ------------------------------------------------------------- CREATE TYPE SYSUDTLIB.udt_int AS INTEGER FINAL INSTANCE METHOD intordering ( ) RETURNS INTEGER SPECIFIC udt_int_int_ordering_24a8_r LANGUAGE C NO SQL PARAMETER STYLE SQL DETERMINISTIC RETURNS NULL ON NULL INPUT, INSTANCE METHOD int_fromsql ( ) RETURNS INTEGER SPECIFIC udt_int_int_fromsql_24a9_r LANGUAGE C NO SQL PARAMETER STYLE SQL DETERMINISTIC RETURNS NULL ON NULL INPUT; SHOW TYPE udtint; *** Text of DDL statement returned. *** Total elapsed time was 5 seconds. ------------------------------------------------------ CREATE TYPE SYSUDTLIB.udt_int AS INTEGER FINAL INSTANCE METHOD int_ordering ( ) RETURNS INTEGER SPECIFIC udt_int_int_ordering_24a8_r LANGUAGE C NO SQL PARAMETER STYLE SQL DETERMINISTIC RETURNS NULL ON NULL INPUT, INSTANCE METHOD int_fromsql ( ) RETURNS INTEGER SPECIFIC udt_int_int_fromsql_24a9_r LANGUAGE C NO SQL PARAMETER STYLE SQL DETERMINISTIC RETURNS NULL ON NULL INPUT;