Teradata Database Message 9455 - 9455 - Analytics Database - Teradata Vantage

Message

ALC specification has invalid options: %VSTR.

Explanation

The algorithmic compression specification should coincide with below: a)DETERMINISTIC Flag b)NULL ON NULL INPUT Flag c)FOR COMPRESS/DECOMPRESS Flag d)Only SCALAR UDFs are allowed e)Compress UDF with output parameter of VARBYTE f)Decompress UDF with input parameter of VARBYTE g)Column data type should be compatible with decompress UDF output parameter type h)UDF input and output parameter length should be less than column length i)The column CharSet should match with Compress UDF's output parameter CharSet.

Generated By

RES.

For Whom

End User.

Notes

None

Remedy

Fix the problem, and submit the SQL again.