This version of Sybase IQ includes the user-defined function samples my_md5, my_byte_length, and my_toupper.
- my_md5 calculates the MD5 hash value of an input file (a LONG BINARY argument) and processes up to 4GB of input data.
- my_byte_length measures the size of a column by streaming the data in piece by piece, then returns the size of the column in bytes.
- my_toupper converts to uppercase all alphabetical characters in a CHAR column.
In the Sybase IQ documentation, see User-Defined Functions > Scalar User-Defined Functions.