Teradata Database Message 9452 - 9452 - Analytics Database - Teradata Vantage

Message

%VSTR not found in SYSUDTLIB/TD_SYSFNLIB.

Explanation

When algorithmic compression clause is specified for a column, the compress/decompress UDFs are expected to be created in SYSUDTLIB/TD_SYSFNLIB. If created, then the compression specification should coincide with below: a)Column data type should be compatible with compress UDF input parameter type b)Column data type should be compatible with decompress UDF output parameter type c)Column Length should be less than or equal to UDF input and output parameter. d)The column CharSet should match with Compress UDFs input parameter CharSet and Decompress UDFs output parameter CharSet.

Generated By

RES.

For Whom

End User.

Notes

None

Remedy

Create the required UDFs before specifying the compress clause. Otherwise, Fix the problem and submit the SQL again.