The fromsql routine maps a UDT value to a predefined data type value. The system invokes it automatically whenever a UDT value is transferred from Teradata Database to a client application.
The external routine invoked by a fromsql clause can be either an external UDF or a method.