Call me confused
UDT as in User Defined Tatatype?
DSNT408I as in "DSNT408I SQLCODE = -xxx, explanation"?
-440 as in " -440 THE NUMBER OF PARAMETERS IN THE PARAMETER LIST DOES NOT MATCH THE NUMBER OF PARAMETERS EXPECTED FOR STORED PROCEDURE name, AUTHID authid, LUNAME luname. number PARAMETERS WERE EXPECTED."?
Obviously I'm missing something, where is the UDT documented, please? The closest I could find were user defined table functions.....
Thanks for the url, down towards the bottom of that page (I think) was this
Built-in functions: When a distinct type is defined, the built-in functions (such as AVG, MAX, and LENGTH) are not automatically supported for the distinct type. You can use a built-in function on a distinct type only after a sourced user-defined function, which is based on the built-in function, has been created for the distinct type. For information on defining sourced user-defined functions, see "CREATE FUNCTION (sourced)" in topic 5.28.